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
- 14374 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
What is sql server replication? : sql server replication
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
Explain powershell included in sql server 2008?
Why olap is used?
How data can be copied from one table to another table?
What is the main purpose of having conversation group?
What is dbcc updateusage?
how many bits ip address consist of? : Sql server database administration
Explain important index characteristics?
What is indexed view? How to create it?
Explain datetime2 data type in sal server 2008?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
What is NOT NULL Constraint in sql server 2012?
How to update multiple rows with one update statement in ms sql server?
How do I trace a query in sql server?
