how to find number of columns in a table in sql server 2000
and 2005 also
- 16 Answers
- 28277 Views
- Virtusa, I also Faced
- E-Mail Answers
Answer Posted / ashutosh jha
select count (*) from tablename.
| Is This Answer Correct ? | 7 Yes | 134 No |
Post New Answer View All Answers
How to select some specific columns from a table in a query in ms sql server?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
Characterize join and name diverse sorts of joins?
What are the requirements on sql server network connections?
How do I start sql server 2017?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
How do you delete a trigger?
Mention the 3 ways to get a count of the number of records in a table.
How to implement service broker?
Would you store your query in a ssrs report or a database server? State the reason why?
How to create stored procedures with parameters in ms sql server?
What it means to be triggered?
What is abstracting periodical?
What are diverse clauses that form a part of sql?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
