how to find number of columns in a table in sql server 2000
and 2005 also
Answer Posted / rajkumar v
select count(*) from information_schema.columns where
table_name='Emp'
EMP table name
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain the difference between cross join and full outer join?
How to delete a database in ms sql server?
How to access the inserted record of an event?
What command would you use to create an index?
Ways to improve the performance of a SQL Azure Database?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
How to filter records of table in SQL SERVER?
How many types of objects are there?
Explain four layers of abstraction microsoft architectured?
How are the exceptions handled in sql server programming?
What are the new scripting capabilities of ssms? : sql server management studio
What are the 2 types of classifications of constraints in the sql server?
how to avoid cursors? : Sql server database administration
How many tables can be joined in SQL Server?
Describe in brief databases and sql server databases architecture.