how to find number of columns in a table in sql server 2000
and 2005 also
Answer Posted / surbhi
SELECT count(*) FROM INFORMATION_SCHEMA.COLUMNS where
table_name='tablename'
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Explain sql server authentication modes?
Explain ranking functions?
Explain nested trigger in sql?
What are the different types of data sources in ssrs?
Explain the phases a transaction has to undergo?
How to rebuild master databse?
How to retrieve field values using mssql_result()?
What is the default server name for sql server?
Is it possible to replicate data from sql server to oracle? : sql server replication
What are recommended options to be used while using db mirroring? : sql server database administration
what are the critical issues you have resloved in your company
What action plan is preferred if sql server is not responding?
What is the difference between grant and with grant while giving permissions to the user?
To which devices can a backup be created and where should these devices be located? : sql server management studio
What is the definition for sql server 2000?