Need the ID for the changed rec in the trigger

[gcole]

I need to pull a field from the changed record in the table so I can pass it to the sp that is execucuted with the trigger. How can I get this information?

 

[nigelrivett]

The new values are available from the inserted table in the trigger.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[gcole]

How do I know which record has been changed? In other words, I want the value in the Rec_ID field from the changed record.

 

[SQLRickster]

If this is an Update or Insert trigger than the rec_id will be in the inserted table and will be called rec_id. For example:

SELECT REC_ID
FROM INSERTED

This will give you the rec_id's of the records that have been changed.

If this is a DELETE trigger it will be in the deleted table.

SELECT REC_ID
FROM DELETED

SQL uses these tables. I kind of think of them as #TEMP tables that are at the system level.

Hope this helps,
SQLRickster