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 / kishore

Answer Posted / kishore

select count(*) NoOfColumns from SYSCOLUMNS
WHERE id= (Select id from SYSOBJECTS where name = 'city')

In this querry may name is Tablename

Is This Answer Correct ?

58 Yes

23 No

Please Help Members By Posting Answers For Below Questions

How retrieve field names from the table in SQL through JAVA code?

1915

Explain can SSRS reports Cache results?

160

How to choose all records from the table?

1072

Explain what are the restrictions while creating batches in sql server?

1079

What are the diifferences between the ms sql server vs mysql?

1179

Differentiate between truncate vs delete in mssql?

1087

Can the query output be sorted by multiple columns in ms sql server?

987

What is difference between standardization and normalization?

1105

Can we check locks in database? If so, how can we do this lock check?

948

How to recover from sql injection? : sql server security

1023

Explain candidate key, alternate key, and composite key?

1003

What are secondary xml indexes?

1031

What is a functions and types in sql server?

1091

What is relationship? What number of sorts of relationship are there?

1143

What is a dataset and what are the different types of datasets?

136