Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS” and “Latin1_General_CI_AS” in the equal to operation

by

I do the following:

...WHERE 
    fieldname COLLATE DATABASE_DEFAULT = otherfieldname COLLATE DATABASE_DEFAULT

Works every time. 🙂

More Related Contents:

  1. Get first day of week in SQL Server
  2. SELECT DISTINCT on one column
  3. Confused about UPDLOCK, HOLDLOCK
  4. Retrieve column definition for stored procedure result set
  5. SQL Server split CSV into multiple rows
  6. Using varchar(MAX) vs TEXT on SQL Server
  7. Change Notification with Sql Server 2008
  8. How do you create a yes/no boolean field in SQL server?
  9. Connecting to MS SQL Server with Windows Authentication using Python?
  10. Using COALESCE function to make values separated with commas
  11. TSQL Email Validation (without regex)
  12. How to find the port for MS SQL Server 2008?
  13. How do I create a multiple-table check constraint?
  14. How to convert number of minutes to hh:mm format in TSQL?
  15. Stored Procedure and Permissions – Is EXECUTE enough?
  16. What happens if you don’t commit a transaction to a database (say, SQL Server)?
  17. Dynamically assign filename to excel connection string
  18. SQL Server Group by Count of DateTime Per Hour?
  19. Temporarily disable all foreign key constraints
  20. How to import a DBF file in SQL Server
  21. SQL Server Dependencies
  22. SQL Server: Filter output of sp_who2
  23. How can I insert binary file data into a binary SQL field using a simple insert statement?
  24. Why do I get the error “Xml data type is not supported in distributed queries” when querying a linked server for non-xml data?
  25. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  26. Date range overlapping check constraint
  27. What are the differences between Merge Join and Lookup transformations in SSIS?
  28. Table Valued Function Killing My Query Performance
  29. Pivot multiple columns based on one column in SQL Server
  30. How to do Sql Server CE table update from another table

Leave a Comment