how to find number of columns in a table in sql server 2000
and 2005 also
- 16 Answers
- 31380 Views
- Virtusa, I also Faced
- E-Mail Answers
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 different types of subquery?
How raid can influence database performance?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
How to convert numeric expression data types using the cast() function?
What is the primary use of the model database?
What are different types of constraints?
What is self contained sub query?
What is normalization and what are the advantages of it?
Does view occupy space?
How to connect php with different port numbers?
How can I check that whether automatic statistic update is enabled or not?
How do I find query history in sql server?
what is the difference between openrowset and openquery?
Explain “row_number()” in sql server with an example?
Can you index views?
