1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| use master
go
MERGE INTO [DESKTOP-RSHSD6C].[GESTIONPETROLE].[dbo].[AchatFournisseur] AS target
USING OPENQUERY (
[DESKTOP-RSHSD6C\SQLEXPRESS],
'SELECT * FROM [DESKTOP-RSHSD6C\SQLEXPRESS].[GESTIONPETROLE].[dbo].[AchatFournisseur]'
) AS source
ON source.[IdAchat]=target.[IdAchat]
WHEN MATCHED THEN
UPDATE SET [IdAchat]=source.[IdAchat],[Dates]=source.[Dates],[IDDEPOT]=source.[IDDEPOT],[IDPRODUIT]=source.[IDPRODUIT],[IDFOURNISSEUR]=source.[IDFOURNISSEUR],[NumeroBon]=source.[NumeroBon],[QUANTITE]=source.[QUANTITE]
,[IDMOUVEMENT]=source.[IDMOUVEMENT],[Date_Expedition]=source.[Date_Expedition],[QTEEXPEDIER_AM]=source.[QTEEXPEDIER_AM],[QTEEXPEDIER_15]=source.[QTEEXPEDIER_15],[Date_Entree]=source.[Date_Entree]
,[ENTREE]=source.[ENTREE],[QTERECUE_15]=source.[QTERECUE_15],[NUMFACTURE]=source.[NUMFACTURE]
WHEN NOT MATCHED BY TARGET THEN
INSERT ([IdAchat],[Dates],[IDDEPOT],[IDPRODUIT],[IDFOURNISSEUR],[NumeroBon],[QUANTITE]
,[IDMOUVEMENT],[Date_Expedition],[QTEEXPEDIER_AM],[QTEEXPEDIER_15],[Date_Entree]
,[ENTREE],[QTERECUE_15],[NUMFACTURE])
VALUES (source.[IdAchat],source.[Dates],source.[IDDEPOT],source.[IDPRODUIT],source.[IDFOURNISSEUR],source.[NumeroBon],source.[QUANTITE]
,source.[IDMOUVEMENT],source.[Date_Expedition],source.[QTEEXPEDIER_AM],source.[QTEEXPEDIER_15],source.[Date_Entree]
,source.[ENTREE],source.[QTERECUE_15],source.[NUMFACTURE]); |
Partager