
复制MERGE a AS TARGET USING ( SELECT id,据同G及解决name FROM b ) AS SOURCE ON (TARGET.[id] = SOURCE.[id]) WHEN MATCHED AND CHECKSUM(TARGET.Name)!= CHECKSUM(CONVERT(NVARCHAR(40),SOURCE.[Name])) THEN UPDATE SET TARGET.[Name] = SOURCE.[Name], WHEN NOT MATCHED BY TARGET THEN INSERT ( [id] ,[Name] ) VALUES( SOURCE.[ID] ,SOURCE.[Name] ) WHEN NOT MATCHED BY SOURCE THEN Delete .... 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.


相关文章
精彩导读
热门资讯
关注我们
