how to find number of columns in a table in sql server 2000 and 2005 also
SELECT count(*) NoOfColumns FROM SYSCOLUMNS WHERE id= (Select id from SYSOBJECTS where name = 'TableName')
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
