Simple trigger question

[Gaylord]

Hi,

This is my first attempt at a trigger and I seem to be having a bit of a brain freeze!

I insert a record into a table with basic user info, a trigger then grabs the newly inserted information and puts it into a second table for later use. However whenever i do this it takes everything that is currently in the table (new_user) and adds it to the second table (data)

I think I am being very slow here, but help please!

CREATE TRIGGER [INSERT_RECORD]
ON [dbo].[new_user]
FOR INSERT
AS
INSERT INTO data (emp_no)
SELECT new_user.user_id
FROM new_user
WHERE new_user.user_id = user_id

Thanks

Jamie

 

[mrdenny]

You almost got it. You want to referance a virtual table called inserted

CREATE TRIGGER [INSERT_RECORD] 
ON [dbo].[new_user] 
FOR INSERT 
AS
INSERT INTO data (emp_no) 
SELECT user_id
FROM inserted

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[dbomrrsm]

CREATE TRIGGER [INSERT_RECORD]
ON [dbo].[new_user]
FOR INSERT
AS
INSERT INTO data (emp_no)
SELECT new_user.user_id
FROM inserted
WHERE new_user.user_id = user_id

[blue]DBomrrsm[/blue]

 

[swampBoogie]

CREATE TRIGGER INSERT_RECORD
ON dbo.new_user
FOR INSERT
AS
INSERT INTO data (emp_no)
SELECT user_id
FROM  inserted

 

[Gaylord]

Thank you so much. I will try the next few steps now!

Cheers Guys

Jamie