insert into tab_name1 (uId,uEmail,typeName)
select top 3 uId , kkEmail,kkTypeName from Tab_other我想执行的同时做插入到另一个表
insert into tab_name2 (uId2,uEmail2,typeName2)======
即我本来想 类似做这样的操作.insert into tab_name1 (uId,uEmail,typeName)
insert into tab_name2 (uId2,uEmail2,typeName2)
select top 3 uId , kkEmail,kkTypeName from Tab_other请问怎么执行呢?
select top 3 uId , kkEmail,kkTypeName from Tab_other我想执行的同时做插入到另一个表
insert into tab_name2 (uId2,uEmail2,typeName2)======
即我本来想 类似做这样的操作.insert into tab_name1 (uId,uEmail,typeName)
insert into tab_name2 (uId2,uEmail2,typeName2)
select top 3 uId , kkEmail,kkTypeName from Tab_other请问怎么执行呢?
insert into tab_name1 (uId,uEmail,typeName)
select top 3 uId , kkEmail,kkTypeName from Tab_other
insert into tab_name2 (uId2,uEmail2,typeName2)
select top 3 uId , kkEmail,kkTypeName from Tab_other
commit
我是想将刚刚插入到 tab_name1 中的uId,uEmail,再插入到 第二个表 Tab_other
on tab_name1
for insert
as
begin
insert into Tab_other
select uId,uEmail
from inserted
end
insert into tab_name1 (uId,uEmail,typeName)
OUTPUT INSERTED.uId,INSERTED.uEmail,INSERTED.typeName
INTO tab_name2
select top 3 uId , kkEmail,kkTypeName from Tab_other
output inserted.uId,inserted.uEmail,inserted.typeName into tab_name2
select top 3 uId , kkEmail,kkTypeName from Tab_other