質問編集履歴
2
SQK文の字下げ対応
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -21,13 +21,14 @@
|
|
|
21
21
|
```SQL
|
|
22
22
|
CREATE TRIGGER [トリガー名] ON [テーブルA]
|
|
23
23
|
AFTER INSERT
|
|
24
|
+
AS
|
|
24
|
-
|
|
25
|
+
BEGIN
|
|
25
|
-
update [テーブルB]
|
|
26
|
+
update [テーブルB]
|
|
26
|
-
set [テーブルB].key1 = [テーブルA].key2
|
|
27
|
+
set [テーブルB].key1 = [テーブルA].key2
|
|
27
|
-
from [テーブルA]
|
|
28
|
+
from [テーブルA]
|
|
28
|
-
where [テーブルB].key3 = [テーブルA].key3 and
|
|
29
|
+
where [テーブルB].key3 = [テーブルA].key3 and
|
|
29
|
-
|
|
30
|
+
[テーブルB].key4 = [テーブルA].key4 and
|
|
30
|
-
|
|
31
|
+
[テーブルA].key5 = 0;
|
|
31
32
|
END
|
|
32
33
|
```
|
|
33
34
|
|
1
省略していたwhere句を追記しました。
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -25,7 +25,9 @@
|
|
|
25
25
|
update [テーブルB]
|
|
26
26
|
set [テーブルB].key1 = [テーブルA].key2
|
|
27
27
|
from [テーブルA]
|
|
28
|
+
where [テーブルB].key3 = [テーブルA].key3 and
|
|
29
|
+
[テーブルB].key4 = [テーブルA].key4 and
|
|
28
|
-
|
|
30
|
+
[テーブルA].key5 = 0;
|
|
29
31
|
END
|
|
30
32
|
```
|
|
31
33
|
|