how to find number of columns in a table in sql server 2000
and 2005 also
Answer Posted / mohan
Guys.. Why don;t you try for the Columns bided with User
Defined Data Type and try the above queries... and Also try
for the Auto incremented Columns..(Identity)....
Your opinion would change definately....
Try out...
I am sure it doesn't take account of UDT Binded Coulmns
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What are unicode character string data types in ms sql server?
Can I disable or restrict ssrs export formats (rendering formats)?
What do we need queues in sql service broker?
Give an example of why you would want to denormalize a database
What is difference between line feed ( ) and carriage return ( )?
What is the use of toad or sqldbx.?
How to create sub reports?
Tell me in brief how sql server enhances scalability of the database system?
What are the advantages of stored procedure in sql server?
What is code near application topology?
What is the difference between row_number and dense_rank?
What is the sql server agent?
What method is used by the Command classes to execute SQL statements that return single values?
What is transaction server distributed transaction?
When cursors are useful?