1 2 3 4 5 6
| MERGE INTO dbo.APP_USER AS a1
USING (SELECT * FROM dbo.APP_USER_TEMP) AS a2
ON (dbo.APP_USER.LOGIN = dbo.APP_USER_TEMP.LOGIN)
WHEN NOT MATCHED THEN
INSERT (a1.ID_PROFILE, a1.NAME, a1.LOGIN, a1.SID, a1.EMAIL, a1.LOGIN_DELEGATE, a1.DELEGATION_DATE_BEGIN, a1.DELEGATION_DATE_END, a1.ENABLE_END_DATE, a1.IS_PCR_ACTOR, a1.ID_PCR_ACTOR_TYPE, a1.ID_PCR_ACTOR_LEVEL, a1.ID_PCR_BG, a1.IS_CLAIM_ACTOR, a1.ID_CLAIM_ACTOR_TYPE) VALUES (a2.ID_PROFILE, a2.NAME, a2.LOGIN, a2.SID, a2.EMAIL, a2.LOGIN_DELEGATE, a2.DELEGATION_DATE_BEGIN, a2.DELEGATION_DATE_END, a2.ENABLE_END_DATE, a2.IS_PCR_ACTOR, a2.ID_PCR_ACTOR_TYPE, a2.ID_PCR_ACTOR_LEVEL, a2.ID_PCR_BG, a2.IS_CLAIM_ACTOR, a2.ID_CLAIM_ACTOR_TYPE)
GO |
Partager