how to find number of columns in a table in sql server 2000
and 2005 also
Answer Posted / ashutosh jha
select count (*) from tablename.
Is This Answer Correct ? | 7 Yes | 134 No |
Post New Answer View All Answers
What is difference in performance between insert top (n) into table and using top with insert?
What is merge join?
how you can list all the tables in a database?
You want to use a perspective in an mdx query. How do you select the perspective?
How to execute stored procedure in select statement sql server?
What is a self join in sql server?
Do you know what are pages and extents? : SQL Server Architecture
Explain cross join or cartesian product in sql?
What is RMS migrations?
How to get the definition of a stored procedure back?
What is catalog views?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
What you can do to delete a table without the delete trigger firing?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
How to find out what is the default collation in a database?