IN SQLSERVER 20005 SELECT COUNT(COLUMN_NAME) FROM INFORMATION

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

Question Posted / sudhir kumar

Answer Posted / sudhir kumar

IN SQLSERVER 20005

SELECT COUNT(COLUMN_NAME) FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'TABLENAME'

try in sql server 2000

Is This Answer Correct ?

29 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Do you know clustered and non-clustered index?

972

Explain subquery and state its properties?

1034

How many categories of data types used by sql server?

1007

What is the difference between resultset and resultsetmetadata?

949

How to write a query with an inner join in ms sql server?

1035

What is the tcp/ip port on which sql server runs?

1142

How to create a dml trigger using create trigger statements?

1024

What are binary string data types in ms sql server?

1274

what happens on checkpoint? : Sql server database administration

1087

What is the most common trace flags used with sql server?

1033

Why use identity in sql server?

1089

Do you know the capabilities of cursors?

1141

How many types of functions are there in sql server?

931

Can you please explain the difference between function and stored procedure?

999

What are the ways available in sql server to execute sql statements?

1106