Few days ago I had copied some tables, Stored Procedures, Views etc from one database to a new database.
Now whenever I execute a Stored procedure, I got below error:
"Cannot resolve collation conflict for equal to operation."
Thre error clearly indicates that the collation types for the columns being joined in the sql statement is different.
I had overcome this error by telling the columns to use the databases default collation on either side of the join fixed the problem - e.g.
SELECT table1.*, table2.* FROM table1
INNER JOIN table2 ON table1.column1 COLLATE DATABASE_DEFAULT = table2.column1 COLLATE DATABASE_DEFAULT
Now whenever I execute a Stored procedure, I got below error:
"Cannot resolve collation conflict for equal to operation."
Thre error clearly indicates that the collation types for the columns being joined in the sql statement is different.
I had overcome this error by telling the columns to use the databases default collation on either side of the join fixed the problem - e.g.
SELECT table1.*, table2.* FROM table1
INNER JOIN table2 ON table1.column1 COLLATE DATABASE_DEFAULT = table2.column1 COLLATE DATABASE_DEFAULT
No comments:
Post a Comment