高手: Sql 语句插入数据解决方案

2012-05-16

高手: Sql 语句插入数据insert into tab_name1 (uId,uEmail,typeName)select top 3 uId , kkEmail,kkTypeN

高手: Sql 语句插入数据
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

请问怎么执行呢？

[解决办法]

探讨
在tab_name1 上建立触发器

create trigger t1
on tab_name1
for insert
as
begin
insert into Tab_other
select uId,uEmail
from inserted
end

[解决办法]
用output就行了

SQL code

insert into tab_name1 (uId,uEmail,typeName) OUTPUT INSERTED.uId,INSERTED.uEmail,INSERTED.typeNameINTO tab_name2select top 3 uId , kkEmail,kkTypeName from Tab_other

热点排行

SQL Server

高手: Sql 语句插入数据解决方案