how to find number of columns in a table in sql server 2000
and 2005 also
Answer Posted / ashutosh jha
select count (*) from tablename.
Is This Answer Correct ? | 7 Yes | 134 No |
Post New Answer View All Answers
What does the not null constraint do?
How do I install sql server?
How can we call UDF(User Define Function) using C# code in ASP.net ?
What is 2nf normalization?
How can I create a report based on a query? : sql server management studio
Where are SQL server users names and passwords are stored in sql server?
How do I create a trace in sql server?
What is the difference between a "where" clause and a "having" clause?
Can I disable or restrict ssrs export formats (rendering formats)?
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?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
Difference between group by clause and having clause in SQL?
How to create a simple user defined function in ms sql server?
Explain use of expression builder.
can a database be shrunk with users active? : Sql server administration