SELECT count(*) NoOfColumns FROM SYSCOLUMNS WHERE id= (Select id from SYSO

how to find number of columns in a table in sql server 2000
and 2005 also

Question Posted / amit

Answer Posted / amit

SELECT count(*) NoOfColumns FROM SYSCOLUMNS
WHERE id= (Select id from SYSOBJECTS where name
= 'TableName')

Is This Answer Correct ?

6 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Does a full backup include transaction log?

1052

What is a deadlock and what is a live lock?

1042

How many types of schemas are there?

1094

How to loop through the result set with @@fetch_status?

1443

what are database files and filegroups? : Sql server database administration

1000

How to divide query output into multiple groups with the group by clause in ms sql server?

1092

What is database mirroring?

1176

How to verify a user name with sqlcmd tool?

1122

How to use the inserted and deleted pseudo tables?

1006

What is page-level compression?

1011

How to join two tables in a single query in ms sql server?

1061

Does partitioning ssd reduce performance?

930

Which language is supported by sql server?

1067

Mention the differences between local and global temporary tables.

1110

What are the steps you can take to avoid “deadlocks”?

1026