how to find number of columns in a table in sql server 2000
and 2005 also
Answer Posted / vidit tyagi
SELECT Count(*)As Coloumns
FROM SysColumns
Where ID =
(SELECT ID FROM SysObjects Where Name = 'TableName')
Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
How to download and install the scaled-down database adventureworkslt?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
What is Transparent Data Encryption?
What are the steps to insert a table?
What are the different authentication modes in sql server?
What command do we use to rename a database?
What is Federation Root Database?
What is inner join? Explain with an example?
How many types of triggers are there?
What are “lost updates”?
Why olap is used?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
How to loop through result set objects using odbc_fetch_row()?
What are a database and a data warehouse?
How you trouble shoot when any job fails