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 is the return type of executeupdate ()?

953

Explain about merge replications?

1081

Does index slows down insert statements?

1047

What does executeupdate return?

1034

Can we add our custom code in ssis?

1040

Why and when do stored procedure recompile?

1031

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

1056

What is a partition key?

1033

What are the 3 types of schema?

1178

Explain the categories of stored procedure?

982

Explain different types of locks in sql server.

1131

Write down the syntax and an example for create, rename and delete index?

1028

How do I view views in sql server?

1063

How to connect sql server management studio express to sql server 2005 express?

1103

Where is localdb stored?

995