how to find number of columns in a table in sql server 2000 and 2005 also
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
To Refer this Site to Your Friends 
Site Map
