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

i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

5 Answers   Aptech,


What are the OS services that the SQL Server installation adds?

3 Answers  


What is the difference between UNIQUE and DISTINCT keywords in DBMS?

1 Answers   Genpact,


Can a table be created inside a trigger?

0 Answers  


Does hive support indexing?

0 Answers  


How to find the date and time of last updated table?

6 Answers   Teledata,


After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )

3 Answers   CarrizalSoft Technologies, iGate,


What is RAID and what are different types of RAID configurations?

8 Answers   Wipro,


Is foreign key a primary key?

0 Answers  


What is the difference between substr and charindex in the sql server?

0 Answers  


WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,...

2 Answers   TVS,


What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

3 Answers   HCL,


Categories