how to find number of columns in a table in sql server 2000
and 2005 also
Answer Posted / bhaskar
select count(*) from syscolumns where id=(select id from
Sysobjects where [name]='Table_Name')
Is This Answer Correct ? | 13 Yes | 3 No |
Post New Answer View All Answers
What are the steps you should follow to start sql server in single-user mode?
How does index makes search faster?
What are the different types of sql server replication? : sql server replication
How to delete duplicate rows?
Mention the command used to rename the database.
How to store and query spatial data?
What are key constraints?
Are null values the same as that of zero or a blank space?
How to defragment table indexes?
Where is trigger in sql server?
How is sql server used?
Why should one not prefix user stored procedures with ‘sp_’?
Describe different Processing Modes offered by SSRS?
Do you know how to store and query spatial data?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?