在等于操作中無法解決“SQL_Latin1_General_CP1_CI_AS”和“Latin1_General_CI_AS”之間的排序規(guī)則沖突我有以下代碼SELECT tA.FieldName As [Field Name],
COALESCE(tO_A.[desc], tO_B.[desc], tO_C.Name, tA.OldVAlue) AS [Old Value],
COALESCE(tN_A.[desc], tN_B.[desc], tN_C.Name, tA.NewValue) AS [New Value],
U.UserName AS [User Name],
CONVERT(varchar, tA.ChangeDate) AS [Change Date]
FROM D tA JOIN
[DRTS].[dbo].[User] U
ON tA.UserID = U.UserID LEFT JOIN
A tO_A
on tA.FieldName = 'AID'
AND tA.oldValue = CONVERT(VARCHAR, tO_A.ID)
LEFT JOIN
A tN_A
on tA.FieldName = 'AID'
AND tA.newValue = CONVERT(VARCHAR, tN_A.ID)
LEFT JOIN
B tO_B
on tA.FieldName = 'BID'
AND tA.oldValue = CONVERT(VARCHAR, tO_B.ID)
LEFT JOIN
B tN_B
on tA.FieldName = 'BID'
AND tA.newValue = CONVERT(VARCHAR, tN_B.ID)
LEFT JOIN
C tO_C
on tA.FieldName = 'CID'
AND tA.oldValue = tO_C.Name LEFT JOIN
C tN_C
on tA.FieldName = 'CID'
AND tA.newValue = tN_C.Name WHERE U.Fullname = @SearchTermORDER BY tA.ChangeDate在運行代碼時,我在為表C添加兩個連接后得到了標(biāo)題中粘貼的錯誤。我認為這可能與我使用SQL Server 2008的事實有關(guān),并已將此數(shù)據(jù)庫的副本還原到我的機器是2005年。
在等于操作中無法解決“SQL_Latin1_General_CP1_CI_AS”
慕哥9229398
2019-08-09 15:39:48