Rows and columns in a table

  • how many columns and rows in a table?

    Thankyou advance..

  • In SQL Server? That sounds like an Excel question.

    Check out BoL. It's not a hard limit for columns, but a size one. There's no row limit other then diskspace.

    Is this a school or interview question?


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • Craig Farrell (6/26/2011)


    In SQL Server? That sounds like an Excel question.

    Check out BoL. It's not a hard limit for columns, but a size one. There's no row limit other then diskspace.

    Is this a school or interview question?

    Thanks for your reply its a interview Question

  • aarunkumarreddy (6/26/2011)


    Craig Farrell (6/26/2011)


    In SQL Server? That sounds like an Excel question.

    Check out BoL. It's not a hard limit for columns, but a size one. There's no row limit other then diskspace.

    Is this a school or interview question?

    Thanks for your reply its a interview Question

    Beware: this is considered a beginner's question, SQL Server 101. I wouldn't even hire a Junior who couldn't answer this. Anyone worth their salt is going to go way beyond this and you're going to ruin your reputation before you have one. You need to do a lot more research before looking for a position in SQL Server.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply