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
- 16 Answers
- 30100 Views
- Virtusa, I also Faced
- E-Mail Answers
Answer Posted / saravanan p
select count(column_Name) from information_schema.columns
where table_name='tableName'
| Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What do we have to check in database testing?
Can we perform backup restore operation on tempdb? : sql server database administration
Does group by or order by come first?
What is the use of =,==,=== operators?
What is trigger explain with program?
What is bcnf normalization form?
How do you start single user mode in clustered installations?
What is difference between line feed ( ) and carriage return ( )?
Explain following error properties?
Can a cursor be updated? If yes, how you can protect which columns are updated?
What is the difference between a primary key and a unique key? Are they the same?
What is collation?
How can you list all the table constraints in a database?
