How to get ID from table in after insert Trigger ?

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

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

Posted 5-Aug-13 19:11pm

nandkishorre

Updated 5-Aug-13 19:13pm

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Denzil Joseph · Answer 1 · 2013-08-05T19:56:00

Solution 1

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

Posted 5-Aug-13 19:56pm

Denzil Joseph

nandkishorre · Answer 2 · 2013-08-05T20:20:00

Solution 3

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

Posted 5-Aug-13 20:20pm

nandkishorre