Interested to Buy Any Domain ? << Click Here >> for more details...
how to find number of columns in a table in sql server 2000
and 2005 also
- 16 Answers
- 30458 Views
- Virtusa, I also Faced
- E-Mail Answers
Answer Posted / harshad
select count(*) from information.schema.columns
where table_name='tablename'
//where tablename is name of your sql table.
//do not prefix table name with .dbo
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How much is a sql server license?
Explain important index characteristics?
What is the process of normalising?
Explain the cursor lock types?
What are the types of indexes?
What is the difference between ‘having’ clause and a ‘where’ clause?
What is efficiency data?
Explain the ways to controlling cursor behavior?
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
What new changes are being made in SQL Server?
Differentiate between delete and truncate.
What is scan table/view and seek table/view when its occurs? : sql server database administration
How to connect a database with sql express.?
What is field with example?
What is query processing?
