hi
i want to create a trigger for update in mssql.

in my trigger i want to know which row was updated

how can i achieve this info ?

Use the "inserted" keyword in the trigger.

if you use inside the trigger code:

SELECT * FROM inserted

only the updated rows will be returned.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.