how to find number of columns in a table in sql server 2000
and 2005 also
Answer Posted / mohan
None of the above answer can result the columns which is
having auto incremented (Identity).
Also if a column is binded to user defined data type that
is also excluded....
So the Correct Number of column cannot be resulted in the
above answers.........
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
What is indexed view? How to create it?
Write a SQL queries on Self Join and Inner Join.
What is the sql case statement used for? Explain with an example?
Explain system scalar functions?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
What is the default Port No on which SQL Server listens?
do views contain data ?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
Explain the database you used in your final year project?
Explain filtered indexes?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
What are the new features in sql server 2016?
What is logshipping and its purpose?
What is normalization of database?
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration