Interested to Buy Any Domain ? << Click Here >> for more details...
how to find number of columns in a table in sql server 2000
and 2005 also
- 7 Answers
- 14348 Views
- HCL, Virtusa, I also Faced
- E-Mail Answers
Answer Posted / sujitha
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
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
How you can add messages to the nt event log from within a stored procedure?
What is proper subset of candidate key?
What happens to a statement batch if there is a compilation error?
How many types of stored procedures are there in sql server?
How to get the definition of a stored procedure back?
What is difference between order by and group by?
If the job running very slow what is the action you do
Explain the benefits of user-defined functions?
What is the use of for clause?
Why Master database is required?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
Does a specific recovery model need to be used for a replicated database? : sql server replication
What do mean by xml datatype?
What is sqlservr.exe - process - sql server (sqlex?press)?
Explain the concept of recursive stored procedure.
