select count (*) from tablename.

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

Question Posted / ashutosh jha

Answer Posted / ashutosh jha

Is This Answer Correct ?

7 Yes

134 No

Please Help Members By Posting Answers For Below Questions

What is query parameter in ssrs?

160

How do you debug a procedure in sql server?

943

How to disable stored procedure sql server?

1606

Is resultset an interface?

967

How will you hide an attribute? : sql server analysis services, ssas

958

What is a join in sql?

1092

What is transactional replication?

967

What is a transaction and why is it important?

1091

What is the default value of an integer data type in sql server 2005?

952

Explain nested join?

983

what are the different types of SSRS reports?

153

Can I work with several databases simultaneously? : sql server management studio

988

List the different index configurations possible for a table?

934

What is attribute? : sql server analysis services, ssas

1018

What is exclusive locks?

957