how to find number of columns in a table in sql server 2000
and 2005 also
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
How to get nth highest salary from employee table.
What is field with example?
Is it possible for a stored procedure to call itself or recursive stored procedure?
How do I make a resultset scrollable?
Explain the types of indexes.
What are xml indexes?
What different steps will a sql server developer take to secure sql server?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
Can the query output be sorted by multiple columns in ms sql server?
What area unit the various kinds of info compression introduced in sql server 2008?
Explain how many types of relationship?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What is the difference between varchar and nvarchar datatypes?
Can a function call a stored procedure in sql server?
why would you call update statistics? : Sql server database administration