how to find number of columns in a table in sql server 2000
and 2005 also
- 16 Answers
- 28178 Views
- Virtusa, I also Faced
- E-Mail Answers
Answer Posted / sudhir kumar
IN SQLSERVER 20005
SELECT COUNT(COLUMN_NAME) FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'TABLENAME'
try in sql server 2000
| Is This Answer Correct ? | 29 Yes | 5 No |
Post New Answer View All Answers
What stored procedure can you use to display the current processes?
What is fill factor and pad index?
What are translations and its use? : sql server analysis services, ssas
how would you improve etl (extract, transform, load) throughput?
What stored by the master? : sql server database administration
Can you explain about buffer cash and log cache in sql server?
What are functions in the sql server?
What function does a database engine serve in the sql server?
How do you handle datasets larger than 50 gb?
What is server-level principal?
Why transaction is important?
Why Master database is required?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
How do I view a trc file?
Why we use trigger in sql server with example?
