Sql Server 2005 - Paste trigger update - update, insert row

I want to create a table trigger for insert and update. How can I get the values ​​of the current record that is inserted / updated?

+3
source share
3 answers

inside a trigger, you can use a table named "inserted" to access the values ​​of new records and the new version of updated records. Similarly, a table called "deleted" allows you to access deleted records and the source versions of updated records.

+8
source

"update" ( ) ""

0

, . .

(.. A, , B), ( , ), ORM (Entity framework, NHibernate ..) .

0

Source: https://habr.com/ru/post/1728739/


All Articles