質問編集履歴
2
修正
title
CHANGED
|
@@ -1,1 +1,1 @@
|
|
|
1
|
-
SQL ServerでDELETE
|
|
1
|
+
SQL ServerでDELETEを全部終わらせてからINSERTの処理をしたい
|
body
CHANGED
|
File without changes
|
1
修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -44,7 +44,9 @@
|
|
|
44
44
|
INSERT INTO [MS_UP_DTL]
|
|
45
45
|
(
|
|
46
46
|
[a_CD]
|
|
47
|
-
, [b_CD]
|
|
47
|
+
, [b_CD]
|
|
48
|
+
, [c_CD]
|
|
49
|
+
|
|
48
50
|
, [d_CD]
|
|
49
51
|
, [HYOJI_JUN]
|
|
50
52
|
, [REG_PROGRAM_ID]
|
|
@@ -59,7 +61,9 @@
|
|
|
59
61
|
(
|
|
60
62
|
@key_a_CD
|
|
61
63
|
, @key_b_CD
|
|
64
|
+
, @c_CD
|
|
62
|
-
|
|
65
|
+
, @d_CD
|
|
66
|
+
|
|
63
67
|
, @val_HYOJI_JUN
|
|
64
68
|
, @PROGRAM_ID
|
|
65
69
|
, @val_USER_ID
|