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 ?

Re: create update trigger with parameters mssql 80 80

When you create trigger After AS play with columns_updated() function read in http://msdn.microsoft.com/en-us/library/aa258254(SQL.80).aspx

Re: create update trigger with parameters mssql 80 80

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 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.