how to find number of columns in a table in sql server 2000
and 2005 also
Answer Posted / ajit kumar nayak
select count(*) from syscolumns sy,Sysobjects so
where
sy.id =so.id
and so.name = <table name>
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the differences between ms sql server & oracle?
How to rebuild indexes with alter index ... Rebuild?
What is a partition function in sql server?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
Explain the working of sql privileges?
How do triggers work?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
Explain cdc and sql injection?
Explain what is the difference between union and union all?
What are truncate options available in sql server? : sql server database administration
What is format parameter in ssrs?
Which are new data types introduced in sql server 2008?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
What is the difference between delete and truncate statements?
What is the standby server?