select count(*) from syscolumns where id=(select id from Sysobjects where

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

Question Posted / bhaskar

Answer Posted / bhaskar

select count(*) from syscolumns where id=(select id from
Sysobjects where [name]='Table_Name')

Is This Answer Correct ?

13 Yes

3 No

Please Help Members By Posting Answers For Below Questions

which backup strategy you are following at ur company

2193

What is the difference between primary key and unique constraints?

1010

mention different types of relationships in the dbms?

1087

What are indexers?

1134

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

1123

Explain what role entity and relationship play in an ER diagram.

1111

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

1057

Can you explain powershell included in sql server 2008?

989

When would you use sql joins?

1028

What is the difference between a function and a stored procedure?

1123

What you can do to delete a table without the delete trigger firing?

1012

How do you trace the traffic hitting a sql server?

1189

How do I run sql server 2014?

1054

Can we shrink data file in sql server?

1091

Can you pass expressions to function parameters?

1151