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 the new scripting capabilities of ssms? : sql server management studio
role of sql sever 2005 in database rather than any other database
What do you understand by user-defined function in the sql server?
Distinguish between nested subquery and correlated subquery?
What is the order in which the sql query is executed?
What are parameterized reports?
What are security principals used in sql server 2005?
What are the new data types are introduced in sql 2000?
Explain what is meant by replication of database?
Does the order of columns in update statements matter?
What will be the maximum number of indexes per table?
What are the types of user defined functions in sql server?
Explain time data type in sal server 2008?
Explain tables in SQL Azure?
How to connect ms access to sql servers through odbc?