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


Please Help Members By Posting Answers For Below Questions

What are the system database in sql server 2008?

590


What is a deadlock and what is a live lock?

587


Mention a few common trace flags used with sql server?

551


What are different types of replication in sql server?

578


What is the use of toad or sqldbx.?

730






can an automatic recovery be initiated by a user? : Sql server administration

530


What is optimistic concurrency?

569


Where is localdb stored?

578


Name three of the features managed by the surface area configuration tool? : sql server security

519


Explain about SQLOS?

596


What are the steps to process a single select statement?

524


How to apply cascading referential integrity in place of triggers?

585


What are the advantages of user-defined functions over stored procedures in sql server?

472


can any body tell me how to know the password of current user in sql server

1589


What is the temp table?

555