This question already has an answer here:
SQL: MS SQL Server 2005.
There is tab1 which has integer fields id,f1,f2 .
There is a record (1,1,1) in the tab1.
Can I catch the difference in after update trigger if I run:
1: update tab1 set f1=2, f2=1 where id=1 or 2: update tab1 set f1=2 where id=1 ?
inserted and deleted pseudo-tables in the after update trigger will be the same after the above commands. If it possible, How could I get the list of fields from update command after set key word?
Thank you in advance.
Aucun commentaire:
Enregistrer un commentaire