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
what is a schema in sql server 2005? : Sql server database administration
Difference between LEN() and DATALENGTH() in sql server ?
Give a example to search fr a string in all stored procedure in sql server.
What is the difference between varchar and varchar(max) datatypes?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
Difference between uniqe index and uniqe constraint?
What is the difference between NOROW and LOCKROW?
What is the sql case statement used for?
Explain about the command-line tool SQLCMD?
How the authentication mode can be changed?
What do you understand by integration services in sql server?
What are system databases in ms sql server?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
How to create a new login name in ms sql server?