select count(*) NoOfColumns from SYSCOLUMNS
WHERE id= (Select id from SYSOBJECTS where name = 'emp')
Showing posts with label Find number of columns in a table in sql server 2000 and 2005 also. Show all posts
Showing posts with label Find number of columns in a table in sql server 2000 and 2005 also. Show all posts
Tuesday, August 17, 2010
Subscribe to:
Posts (Atom)