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

Name few endpoints exposed by ssrs 2012?

355

What is a rownum?

978

What Is Rdbms?

1159

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1037

Can we linked SharePoint to a SQL database?

1029

How to optimize stored procedure optimization?

894

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

118

Explain the advantages of merge replication?

952

What is sql server locking?

996

What is the primary use of the model database?

1087

Explain what is sql server english query?

1052

How to grant a permission in ms sql server using "grant execute" statements?

1094

Which tcp/ip port does the sql server run on? How can it be changed?

1053

What is the current pricing model of SQL Azure?

104

How do I start sql server agent automatically?

973