sql Resolve Collation conflicts

SELECT myColumn
FROM myTable
INNER JOIN AccountsTable
WHERE
	myTable.myColumn COLLATE DATABASE_DEFAULT = 
	myOtherTable.myColumn COLLATE DATABASE_DEFAULT
Use this to resolve collation conflicts - when you encounter the error: "Cannot resolve collation conflict for equal to operation"

Updated: Friday 8th October 2010, 11:25pm

There are 0 comments

Leave a comment of your own

Comments are currently closed.