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
What is the difference between cube operator and rollup operator? : SQL Server Architecture
Explain Geography datatype in SQL Server
When you use @@error and try-catch?
SQL Server Architecture ?
How to get the definition of a trigger back?
Explain concepts of analysis services?
What are the advantages of paper records?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What is a transactions?
What is the recursive stored procedure in sql server?
What is meant by indexing?
Can group functions be used in the order by clause in ms sql server?
How many levels of sp nesting is possible?
What happens to a trigger with multiple affected rows?
What is the dbcc command and why is it used?