How to use collate statement MS SQL SERVER

-- example syntax for "collate database_default"
-- "database_default" should be changed to the database collation
SELECT * FROM [DATABASENAME1].dbo.TABLE1 as t1
INNER JOIN [DATABASENAME1].dbo.TABLE2 as t2 ON
t1.column collate database_default = t2.clolumname collate database_default 
 

Comments