TRY BELOW:USE tempdb GOCREATE TABLE TestTab ( id int, GreekCol nvarchar(10) collate greek_ci_as, LatinCol nvarchar(10) collate latin1_general_cs_as ) INSERT TestTab VALUES (1, N'A', N'a') GO--The predicate in the following query has collation conflict and generates an error:SELECT * FROM TestTab WHERE GreekCol = LatinColyou can search SQL BOL of 'Collation Precedence'
GOCREATE TABLE TestTab (
id int,
GreekCol nvarchar(10) collate greek_ci_as,
LatinCol nvarchar(10) collate latin1_general_cs_as
)
INSERT TestTab VALUES (1, N'A', N'a')
GO--The predicate in the following query has collation conflict and generates an error:SELECT *
FROM TestTab
WHERE GreekCol = LatinColyou can search SQL BOL of 'Collation Precedence'