how to find number of columns in a table in sql server 2000
and 2005 also
Answer Posted / mohan
None of the above answer can result the columns which is
having auto incremented (Identity).
Also if a column is binded to user defined data type that
is also excluded....
So the Correct Number of column cannot be resulted in the
above answers.........
Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
What are various aggregate functions that are available?
How can sql server instances be hidden? : sql server security
Can we take the full database backup in log shipping?
Please differentiate between a local and a global temporary table?
How can you know if the row fetched from cursor is still valid in underlying table?
What are the instances when triggers are appropriate?
How to view the error log for any specific instance? : sql server database administration
Write a query for primary key constraint with identity key word?
What is the maximum size of column in sql server?
What are different backups available in sql server?
How do I make a resultset scrollable?
What are three major types of constraints?
Do you know what is a linked server in sql server?
Explain stored procedure?
How to maintain a fill factor in existing indexes?