Case Sensitive JOIN

For case senstive joins use

• COLLATE Latin1_General_CS_AS

For example:

SELECT table1.column1, table1.column2,table2.column1

FROM 

table1 T1 inner join table2 T2

ON

T1.column1 COLLATE Latin1_General_CS_AS = T2.column1 COLLATE Latin1_General_CS_AS