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
- 16 Answers
- 29969 Views
- Virtusa, I also Faced
- E-Mail Answers
Answer Posted / kishore
select count(*) NoOfColumns from SYSCOLUMNS
WHERE id= (Select id from SYSOBJECTS where name = 'city')
In this querry may name is Tablename
| Is This Answer Correct ? | 58 Yes | 23 No |
Post New Answer View All Answers
Define outer join in sql server joins?
How to defragment indexes with alter index ... Reorganize?
What's the information that can be stored inside a bit column?
Give an example of SQL injection attack ?
What is subquery in sql?
Does the unique constraint create an index?
Explain the difference between delete,drop and truncate in SQL Server?
What is unique key constraint?
What is optimization and its types?
How to name query output columns in ms sql server?
How to filter out duplications in the returning rows in ms sql server?
How to get the query of a table in sql server?
What is difference between foreign key and unique key?
Explain about extended stored procedure?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
