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
- 14555 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 many database files are there in sql server 2000?what are they?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
What is data file in computer?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
explain what is raid and what are different types of raid configurations? : Sql server database administration
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
How do I install only the client tools of sql server 2000?
Does table partitioning improve performance?
Can we use trigger new in before insert?
What are information schema views?
What are the High-Availability solutions in SQL Server and differentiate them briefly?
What is identity?
What is log in sql server?
How to enter comments in transact-sql statements?
what kind of lan types do you know? : Sql server database administration
