how to find number of columns in a table in sql server 2000
and 2005 also
Answer Posted / bhaskar
select count(*) from syscolumns where id=(select id from
Sysobjects where [name]='Table_Name')
| Is This Answer Correct ? | 13 Yes | 3 No |
Post New Answer View All Answers
What is the default fill factor value?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
What does man by sql wildcard characters in sql server?
What is difference between primary key and foreign key?
What is blocking and how would you troubleshoot it? : sql server database administration
Will sql server 2005 allow you to reduce the size of a column?
What are commonly used odbc functions in php?
What is the parse query button used for?
How to connect to SQL Azure Database by using sqlcmd?
What are the mathematical functions supported by sql server 2005?
What is an indexing strategy?
What is hot add cpu in sql server 2008?
How to return the second 5 rows in ms sql server?
Explain left outer join and right outer join?
How to enable tcp/ip protocol on a sql server?