Can I select a set of rows from a table and directly insert that into a table or the same table in S
Posted
by VJ
on Stack Overflow
See other posts from Stack Overflow
or by VJ
Published on 2010-06-07T17:22:59Z
Indexed on
2010/06/07
19:02 UTC
Read the original article
Hit count: 247
Hi I guess we cannot do this but was just curious if I could do something like -
Select * from Employee where EmployeeId=1
and then use the data in the above statement and directly insert into a table with just changing the employeeid...or just this way-
insert into Employee ( Select * from Employee where EmployeeId=1)
its probably stupid from my side...but I just felt the need to do this a lot of times...so just was curious if there was any way to achieve it..
© Stack Overflow or respective owner
