When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

How to return the second 5 rows in ms sql server?

0 Answers  


What is openrowset sql server?

0 Answers  


Explain the functionalities that views support?

0 Answers  


How to create an inline table-valued function?

0 Answers  


What is spatial and temporal data?

0 Answers  






How to provide default values to function parameters?

0 Answers  


How many categories of functions based their return modes?

0 Answers  


What are the fixed server level roles? : sql server security

0 Answers  


you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

0 Answers  


Is foreign key a primary key?

0 Answers  


Write a sql query to display the current date?

0 Answers  


How do you persist objects, permissions in tempdb

1 Answers  


Categories