While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
No Answer is Posted For this Question
Be the First to Post Answer
How to find out what is the default collation in a database?
If a table does not have a unique index, can a cursor be opened on it?
What is the difference between varchar and varchar(max) datatypes?
How do I make a resultset scrollable?
How many databases Microsoft SQL server provides?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
Can someone suggest me the best institute to learn SQL Server... I want to gain in depth knowledge on SQL Server Development. I have been to naresh, peers, sql school,mind q systems... Any idea about best faculty....
Why use triggers?
what are default? Is there a column to which a default cant be bound?
How column data types are determined in a view?
What are the type of Indexes? which one is best, why?