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

How to create a store procedure with encryption?

945

What are the advantages of using stored procedures?

887

What is surrogate key? : sql server analysis services, ssas

1053

How to use subqueries with the exists operators in ms sql server?

1055

What is the main purpose of having conversation group?

845

what is database replicaion? : Sql server database administration

1100

What do you mean by an execution plan?

1050

Explain the benefits of user-defined functions?

985

List out the differences between the clustered index and non-clustered index in sql server?

942

What are the different types of indexes?

1043

How to list all user defined functions in the current database?

971

Explain the use of containers in ssis and also their types?

906

What is use of except clause? How does it differ from not in clause?

960

How you can change the database name in SQL SERVER?

1130

What is the usage of sign function?

1038