SQL 比對兩資料表兩欄位以上不重複

SELECT [Ex_Date] ,[From_Currency] ,[To_Currency] ,[Ex_Rate] ,[Create_Date] ,[Create_User] ,[Modify_Date] ,[Modify_User] FROM [BackData].[dbo].[A145] EXCEPT SELECT [Ex_Date] ,[From_Currency] ,[To_Currency] ,[Ex_Rate] ,[Create_Date] ,[Create_User] ,[Modify_Date] ,[Modify_User] FROM [T1S1DB02].[BackData].[dbo].[A145]

修改MS SQL定序

ALTER DATABASE DatabaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE ALTER DATABASE DatabaseName COLLATE Chinese_Taiwan_Stroke_CI_AS /*定序*/ ALTER DATABASE DatabaseName SET MULTI_USER WITH ROLLBACK IMMEDIATE