how to find number of columns in a table in sql server 2000
and 2005 also
- 16 Answers
- 27430 Views
- Virtusa, I also Faced
- E-Mail Answers
Answer Posted / ajit kumar nayak
select count(*) from syscolumns sy,Sysobjects so
where
sy.id =so.id
and so.name = <table name>
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to execute a sql statement using odbc_exec()?
Differentiate between delete and truncate.
What are the different Topologies in which Replication can be configured?
According to you what goes into making the best database administrator? : sql server database administration
How to list all dsn entries on your local machine using odbc_data_source()?
what are acid properties? : Sql server database administration
What is the name of the system variable that returns the number of rows affected by a SQL statement?
What is difference between global temporary tables and local temporary tables?
What function does a database engine serve in the sql server?
What is bcp? When does it used?
How do I find information about the install locations for the various instances running on a computer?
What is the chart in report?
Detail about query optimizer?
Define right outer join?
What is built-in/administrator?
