T-SQL
-
Hi there, Is there a way to include a value from the affected record into a AFTER UPDATE trigger? And if there is a way, can you give me an exapmle, please? Thanks, Werries
A programmer's life is good... or is it?? Ek dink nie so nie!
Use the
insertedordeletedpseudo-tables depending on whether you want the values after or before the update occurred. Remember that more than one record can be affected by a statement, but that the trigger only fires once, regardless of the number of records affected.Stability. What an interesting concept. -- Chris Maunder
-
Use the
insertedordeletedpseudo-tables depending on whether you want the values after or before the update occurred. Remember that more than one record can be affected by a statement, but that the trigger only fires once, regardless of the number of records affected.Stability. What an interesting concept. -- Chris Maunder
-
Thanks for your reply Chris, I appreciate it. Regards, Werries
A programmer's life is good... or is it?? Ek dink nie so nie!
Werries wrote:
Chris
Who's Chris?
Upcoming events: * Glasgow: SQL Server 2005 - XML and XML Query Plans, Mock Objects, SQL Server Reporting Services... Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton My website