You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
MERGE INTO 退職社員マスタ T1
USING (SELECT
S1.社員コード
,S1.社員名
,S1.年齢
FROM 社員マスタ S1
WHERE S1.年齢 >= 30)
ON (
T1.社員コード = S1.社員コード
AND 社員コード = 2)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
WHEN MATCHED THEN
UPDATE SET
T1.社員名 = S1.社員名
,T1.年齢 = S1.年齢
WHEN NOT MATCHED THEN
INSERT(
社員コード
,社員名
,年齢
)VALUES(
S1.社員コード
,S1.社員名
,S1.年齢
)
The text was updated successfully, but these errors were encountered:
対策としてMergeStmtのConstraintプロパティをPredicate型からBracketedPredicate型に変更する方法がある。
The text was updated successfully, but these errors were encountered: