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

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

1124

What are database states in ms sql server?

1111

What is the difference between index seek vs. Index scan?

968

Write a code to select distinct records without using the DISTINCT keyword.

1048

What is a trigger in sql server?

1085

What are the benefits of filtered indexes?

977

What are the different kinds of ssrs reports?

206

How many types of keys are there?

961

Can you leave a union at any time?

998

How to execute a sql statement using odbc_exec()?

1053

What are null values in ms sql server?

1018

What does the on update no action do?

959

can an automatic recovery be initiated by a user? : Sql server administration

892

Explain what is use of dbcc commands?

987

Why use cursor in sql server?

1004