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
- 14313 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
what is a self join? Explain it with an example? : Sql server database administration
Can I disable or restrict ssrs export formats (rendering formats)?
Explain log shipping?
Can you type more than one query in the query editor screen at the same time?
How to create sub reports?
Can you force a query to use a specific index?
How many clustered indexes there can be on table ?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
Does partitioning help performance?
What are views in ms sql server?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
How to view the error log for any specific instance? : sql server database administration
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
Give main differences between "Truncate" and "Delete".
What are advantages of ssrs or why we should use ssrs?
