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 are the types of containers in ssis?
How can a user-defined datatype be created?
can we have a nested transaction? : Sql server database administration
How to identify current user in ssrs report?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
What is explicit mode in sql server?
What is difference between sql and sql server?
Comment,Datatypes are unlimited
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
what are constraints? Explain different types of constraints? : Sql server database administration
Explain transaction server distributed transaction?
What according to you is the difference between mysql and sql server performance?
What is a not null constraint?
What are page splits?
explain databases and sql server databases architecture? : Sql server database administration