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 the difference between for auto and for nested?

1001

How to create an identity column?

1218

What is an indice?

1031

how we use window authentication connection with sql server.?

1152

Write a SQL query in order to merge two different columns into single column?

1034

When to use null data driven subscription?

206

How to truncate the log in sql server 2012? : sql server database administration

1283

What is a covered index?

937

How to define output parameters in stored procedures?

1027

What are the 3 types of schema?

1110

How to rebuild master databse?

1077

How to change the system date and time from SQL Plus Terminal ?

1217

What is a hint?

991

How to get the number of affected rows?

998

How do I know if localdb is running?

949