Getting Started with Adobe After Effects - Part 6: Motion Blur
A collection of quick technology learning tips from what people around you learn every day

Quick fix to SQL Server collation error - Cannot resolve collation conflict for equal to operation

Jul 12 2012 12:00AM by RKA   

While writing a query with joining two tables from two different dbs, a collation error was encountered. 'Cannot resolve collation conflict for equal to operation.' Fix:

add keyword COLLATE DATABASE_DEFAULT after join .

SELECT <columnname>
FROM  <dbname1>.<dbo>.table1 t1
INNER JOIN<dbname1>.<dbo>.table1 t2
ON t1.colx = t2.coly COLLATE DATABASE_DEFAULT
Read More..   [27 clicks]

Published under: General Technology Tips ·  ·  ·  · 


RKA
92 · 2% · 598
4
 
3
 
 
0
Incorrect
 
0
Interesting
 
0
Forgotten



Submit

1  Comments  

  • Please note that changing the collation changes the way SQL Server interprets string values - the result of a string comparison after changing the collation may be different than expected.

    commented on Jul 14 2012 2:06PM
    Nakul Vachhrajani
    4 · 36% · 11648

Your Comment


Sign Up or Login to post a comment.

"Quick fix to SQL Server collation error - Cannot resolve collation conflict for equal to operation" rated 5 out of 5 by 4 readers
Quick fix to SQL Server collation error - Cannot resolve collation conflict for equal to operation , 5.0 out of 5 based on 4 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]