SELECT Count(*)As Coloumns FROM SysColumns Where ID = (SELECT ID FROM

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

Question Posted / vidit tyagi

Answer Posted / vidit tyagi

SELECT Count(*)As Coloumns
FROM SysColumns
Where ID =
(SELECT ID FROM SysObjects Where Name = 'TableName')

Is This Answer Correct ?

6 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What are the steps you can take to avoid “deadlocks”?

918

Explain what is the difference between union and union all?

950

Explain magic tables in sql server?

981

What is SQL Azure?

105

How many cores do I need for sql server 2016?

847

Can you leave a union at any time?

998

Does sql server use t sql?

952

What is sql server replication? : sql server replication

921

Can group functions be mixed with non-group selection fields in ms sql server?

888

What is key set driven?

892

What are transactions and its controls?

1002

Tell me what do you understand by a view? What does the with check option clause for a view do?

956

When multiple after triggers are attached to sql table, how to control the order of execution?

976

What are secondary xml indexes?

983

What is the use of builtinadministrators group in sql server? : sql server security

965