When Would You Use An Insert Into .. Select Option Versus An Insert I

1.	When Would You Use An Insert Into .. Select Option Versus An Insert Into .. Values Option? Give An Example Of Each?
Answer» INSERT INTO .. SELECT is used insert DATA in to table from DIFFERENT tables or condition BASED insert. INSERT INTO .. VALUES you have to specify the insert values. INSERT INTO .. SELECT is used insert data in to table from different tables or condition based insert. INSERT INTO .. VALUES you have to specify the insert values.

When Would You Use An Insert Into .. Select Option Versus An Insert Into .. Values Option? Give An Example Of Each?

Answer»

INSERT INTO .. SELECT is used insert DATA in to table from DIFFERENT tables or condition BASED insert.
INSERT INTO .. VALUES you have to specify the insert values.

INSERT INTO .. SELECT is used insert data in to table from different tables or condition based insert.
INSERT INTO .. VALUES you have to specify the insert values.

Discussion

No Comment Found

Related InterviewSolutions

Can You Use The On Delete And On Update In The Same Constraint?
What Is The Purpose Of The Model Database?
What Is The Purpose Of The Master Database?
What Is The Purpose Of The Tempdb Database?
What Is The Purpose Of The Use Command?
If You Delete A Table In The Database, Will The Data In The Table Be Deleted Too?
What Is The Parse Query Button Used For?
What Is Usually The First Word In A Sql Query?
Does A Sql Server 2005 Select Statement Require A From?
What Is The Order By Used For?

When Would You Use An Insert Into .. Select Option Versus An Insert Into .. Values Option? Give An Example Of Each?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment