插入Trigger后如何从表中获取ID？ [英] How to get ID from table in after insert Trigger ?

问题描述

大家好，



我在EMP1表上插入触发器后创建。在EMP1表中我没有标识列，在该触发器中我将数据插入EMP2表。在EMP2表中，我有自动增量1的标识（ID）列。将数据插入到EMP2中自动插入的EMP1数据后，还创建了该员工的ID。在这种情况下如何从触发器中的EMP2表中获取该ID？





任何人都可以知道这个告诉我。



问候

Nanda Kishore.CH

Hi to all,

I create after insert trigger on EMP1 table.In EMP1 table i don't have identity column, in that trigger i insert data into EMP2 table.In EMP2 table i have identity (ID)column with auto increment 1. After insert the data into EMP1 data automatically inserted in EMP2 and also created a ID fot that employee. in this case how to get that ID from EMP2 table in that trigger ?


could anyone know about this tell me.

Regards
Nanda Kishore.CH

推荐答案

create table emp1 
(
name varchar(20)
)
go
create table emp2 
(
id int identity(1,1),
name varchar(20)
)
go
create trigger instrg_emp1
on emp1
after insert
as
begin
insert into emp2(name) 
select name from inserted
select @@identity
end
go
insert emp1 values('denzil')
go

从emp2中选择@id = id，其中empname = @empname

select @id = id from emp2 where empname = @empname

这篇关于插入Trigger后如何从表中获取ID？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！