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
How to reaname table name without using sp_Rename in sql server..?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
What happens if you add a new index to large table?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
Can you explain what is indexed view? How to create it?
How to enable tcp/ip protocol on a sql server?
What is the latest version of microsoft sql server?
What are different types of raid configurations? : SQL Server Architecture
What is bcp? When does it use?
What is left outer join in sql server joins?
Do you know data definition language, data control language and data manipulation language?
Where do you find the default Index fill factor and how to change it?
do views contain data ?
How can you check the level of fragmentation on a table?
How to create dbo table in sql server?