how to find number of columns in a table in sql server 2000
and 2005 also
- 7 Answers
- 13101 Views
- HCL, Virtusa, I also Faced
- E-Mail Answers
Answer Posted / sujitha
SELECT DISTINCT SYS.NAME,COUNT(*) FROM SYSOBJECTS SYS
INNER JOIN SYSCOLUMNS SYSCOL ON SYSCOL.ID=SYS.ID
WHERE SYS.XTYPE='U' GROUP BY SYS.NAME
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
How does normalization work?
Tell me what are the essential components of sql server service broker?
What is t-sql script to take database offline – take database online.
What is a system database and what is a user database?
What is subquery? Explain the properties of a subquery?
Why transaction is important?
What is read committed?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
your distribution database is full what will u do
Explain system rowset functions?
How to update a field in SQL after ALTERING a row?
How many joins in sql server?
When would you use it?
How can I track the changes or identify the latest insert-update-delete from a table?
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
