Answer Posted / kishore
select count(*) NoOfColumns from SYSCOLUMNS
WHERE id= (Select id from SYSOBJECTS where name = 'city')
In this querry may name is Tablename
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
How many types of objects are there?
Mention what are the different types of ssrs reports?
What is the use of custom fields in report?
What is the difference between a stored procedure and a user defined function?
What are sub reports?
What options are available to audit login activity? : sql server security
What is the use of for clause?
What is sql server management studio? : sql server management studio
how can you check the level of fragmentation on a table? : Sql server administration
How to set database to be read_only in ms sql server?
What is extent? Types of extents?
Please explain what is “asynchronous” communication in sql server service broker?
What is sql server schema compare? How we can compare two database schemas?
What is data file in computer?
Describe how to use linked server?