query to get number of columns of particular table using sqlserver
select count(*)as NOC from SYSCOLUMNS where id=(select id from SYSOBJECTS where name='tablename')
Subscribe to:
Post Comments (Atom)
SQLQueriesCollection is blog for all sql queries in SqlServer at one place.SQL,SQL Query,SQL Queries,SQL Query Code,SQL Query Example,SQL Query Syntax,Basic Sql Queries,Query,SQL Examples,SQL Basic Queries,Structured Query Language,sql oracle queries,oracle sql queries,sql queries in oracle,sql-oracle,oracle sql.oracle basics,sql basics,oracle sql examples,sql orqcle examples
1 comment:
Thanks so much....Works like wonder!
Post a Comment