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
What is the difference between locking and multi-versioning?
What is constraints and its types?
Why is replication required on the sql server?
Write a sql query to get zero records from a table having n number of records?
What is candidate key with example?
What is a partition key?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
Do you know what are the steps to process a single select statement?
How would we use distinct statement? What is its use?
Describe how to use the linked server?
Can we perform backup restore operation on tempdb?
What are the types of table?
Do you know what are different types of replication in sql server?