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
Do you know what is normalization of database? What are its benefits?
What part does database design plays a role in performance of an sql server-based application?
How will you hide an attribute? : sql server analysis services, ssas
Can you tell me about the concept of ER diagrams?
What program is used to store the data source file?
What are the purposes and advantages stored procedure?
How to update muliple row in single query?
How many ways to create table-valued functions?
What is user defined datatypes and when you should go for them?
When would you prefer to have a minimum number of indexes?
What are user-defined functions (udfs) in sql server?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
How to use old values to define new values in update statements in ms sql server?
What is truncate table?
Can two different columns be merged into single column? Show practically?