how to find number of columns in a table in sql server 2000
and 2005 also
Answer Posted / jerry joseph
SELECT count(*) NoOfColumns FROM SYSCOLUMNS
WHERE id= (Select id from SYSOBJECTS where name = 'TableName')
Is This Answer Correct ? | 14 Yes | 6 No |
Post New Answer View All Answers
Explain about local stored procedure?
Is null vs coalesce?
How can I check if a view exists in a sql server database?
What is primary key index?
How do you size a resultset?
What is the difference between value type and reference type?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
What is a field name?
What is primary key and example?
What is difference between global temporary tables and local temporary tables?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
What is SQL Azure Data sync?
What are the disadvantages of using the stored procedures?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
how can you check the level of fragmentation on a table? : Sql server administration