Most Intelligent
Software Engineer
Wednesday, September 28, 2011
How to count number of columns in a table in sql server2005
SQL Query--1:
select count(*) from information_Schema.columns where table_name='tblNew'
SQL Query--2:
select count(*) from syscolumns where id in (select id from sysobjects where
sysobjects.name
= 'tblNew')
No comments:
Post a Comment
Newer Post
Older Post
Home
View mobile version
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment