How to identify the ID of row which has been modified?

[Mai Phuong]

Hi all,

I have table Demo:

CREATE TABLE Demo
(
ID               int              PRIMARY KEY,
Name         char(50),
BeModified  int             DEFAULT(0)
)

Whenever [Name] is updated, [BeModified] will be set to 1.

I think I should create an TRIGGER AFTER UPDATE

CREATE TRIGGER UpdateRow
 
ON Demo
 
AFTER UPDATE
 
UPDATE Demo
 
Set BeModified = 1 WHERE ID = "???"
 

My problem is I do not know how to identify the ID of row which has been modified.

Have you got any suggestion for me?

Thank you so much!

[ck9663]

Use the DELETED and INSERTED tables.

Happy Coding!!!

--- CK

[Mai Phuong]

I am sorry to bother you but could you explain it more specific?

I did something to understand more about inserted & deleted table, but I get the message "Invalid object name 'inserted'."

[Mai Phuong]

I did it, just by using inserted table.

Thanks for your helping!