vendredi 18 décembre 2015

MSSQL: Can I catch the list of table fields (from update command) in after update trigger? [duplicate]

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