SELECT COUNT(*) FROM SYS.COLUMNS WHERE ID=(SELECT * FROM SYS.OBJECT WHERE

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

Question Posted / ram&saran

Answer Posted / ram&saran

SELECT COUNT(*) FROM SYS.COLUMNS WHERE ID=(SELECT * FROM
SYS.OBJECT WHERE NAME='TABLENAME')

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the approximate numeric data types?

876

Which Model uses the SET concept

934

What is an execution plan? When would you use it?

919

Issues related in upgrading SQL Server 2000 to 2005 / 2008

1832

How many triggers are possible per table?

1038

What are the different Authentication modes in SQL Server and how can you change authentication mode?

1021

Can a synonym name of a table be used instead of a table name in a select statement?

974

how to take backup bcp out for a column in table in sql server?

2044

Explain what are the basic functions for master, msdb, model, tempdb databases?

911

What is the exact numeric data type in sql?

960

How to get a list of all tables with "sys.tables" view in ms sql server?

982

how to use DTS package in 2000,2005,2008 in sql server

1786

How can you find out how many rows returned in a cursor?

970

How to backup encryption key ?

168

Explain following error properties?

955