???????????????? ????????
??? ?????????? ?????? ?????????, ??????????, ??????? ?????? ??????? 2 ??????????? ???????: inserted ? deleted. ????????? ?????? ?????????? ???????, ? ??????? ?????????? ???????. ? ??????????? ?? ??????? ?? ?????????? ??????????:
1. ??????? Insert - ??????? inserted ???????? ??? ??????, ??????? ?? ???????? ???????? ? ??????? (deleted - ??????).
2. ????? ?????????? ???????? ?????? ? ??????? inserted ?????????.
3. ??????? Delete - ? ??????? Deleted ?????????? ?????? ? ???????? (inserted - ??????).
4. ??????? Update - ? deleted - ?????? ???????? ?????; ? inserted - ????? ???????? ?????.
@@ROWCOUNT - ?????????? ?????????? ????? ? ??????? (Inserted ? Deleted).?????? ?? ??????? ?? ??????? Insert:
Create Trigger ??????? <n>
On ?????? For Insert
As
If @@ROWCOUNT = 1
Begin
If not Exist {Select * From Inserted Where Inserted.?????????? <= ALL
(Select * From ?????, ?????? Where ???1 = ???2)}
Begin
RollBack Throw
Print "s"
End
End
???????, ? ????????, ????????????
1. ??? ????? ?????????????? ??????.
2. ??? ?????? ??????? ?????????.
3. ??? ????????? ??????????? ?????? ? ????? ?????? ?????? ?????????.
< Предыдущая | Следующая > |
---|