join tow table with different collation in sqlserver

علی ذوالفقار
1400/12/22 08:25:33 (538)

SELECT MyColumn
FROM 
    FirstTable a
INNER JOIN 
    SecondTable b
ON 
    a.MyID COLLATE DATABASE_DEFAULT = b.YourID COLLATE DATABASE_DEFAULT

Back