how to find number of columns in a table in sql server 2000
and 2005 also
- 16 Answers
- 28205 Views
- Virtusa, I also Faced
- E-Mail Answers
Answer Posted / saravanan p
select count(column_Name) from information_schema.columns
where table_name='tableName'
| Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
Explain the steps needed to create a scheduled job?
What happens if you are trying to access a schema not owned by you?
Define self join?
How do I view a trc file?
what are the important architecture components of SSRS?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
Differentiate sql server reporting services vs. Crystal reports?
How to create a dml trigger using create trigger statements?
Explain “@@rowcount” and “@@error” in sql server?
Describe the functionalities that views support.
Explain the ways to controlling cursor behavior?
Do you know sql server 2008 introduces automatic auditing?
What is a transact-sql statement?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
