Interested to Buy Any Domain ? << Click Here >> for more details...
how to find number of columns in a table in sql server 2000
and 2005 also
- 7 Answers
- 14272 Views
- HCL, Virtusa, I also Faced
- E-Mail Answers
Answer Posted / kumar.t
Select Count(Column_Name) As NoOfColumns From
Information_Schema.Columns Where table_Name='Company'
| Is This Answer Correct ? | 22 Yes | 2 No |
Post New Answer View All Answers
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
Does hive support indexing?
What is the native system stored procedure to execute a command against all databases?
How to use subqueries with the in operators in ms sql server?
Are null values the same as that of zero or a blank space?
How to use linked server?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
What is buffer cash in sql server?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
How to start sql server browser service?
What is entity data services?
What is the difference between varchar and varchar(max) datatypes?
How do you create a clustered index?
What are the dis_advantages of stored procedures, triggers, indexes?
Is INSTEAD OF trigger directly applicable to Table ?
