База на податоци: trigger.sql
File trigger.sql, 422 bytes (added by , 8 years ago) |
---|
Line | |
---|---|
1 | USE [dbVARK] |
2 | GO |
3 | |
4 | /****** Object: Trigger [dbo].[AktiviranjeKod] Script Date: 30.12.2015 03:28:01 ******/ |
5 | SET ANSI_NULLS ON |
6 | GO |
7 | |
8 | SET QUOTED_IDENTIFIER ON |
9 | GO |
10 | |
11 | |
12 | CREATE TRIGGER [dbo].[AktiviranjeKod] |
13 | ON [dbo].[Administratori] |
14 | AFTER INSERT |
15 | AS |
16 | BEGIN |
17 | SET NOCOUNT ON |
18 | UPDATE [dbo].[AdminKod] |
19 | SET Aktiviran = 'true' |
20 | WHERE Kod = (SELECT Verifikaciski_Kod FROM inserted) |
21 | END |
22 | |
23 | GO |
24 |