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
Explain what is public role in sql server?
What is tabulation?
What is merge statement?
What are locks in sql?
What will be the maximum number of indexes per table?
List the various tools available for performance tuning?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What is the purpose of data source?
how can you attach more than 20 ldf files in sql server
What is BCNF? How is it better than 2NF & 3NF?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
What is difference between getdate and sysdatetime in sql server 2008?
Define right outer join in sql server joins?
What is the significance of null value and why should we avoid permitting null values?