[Solved] SQL Server Error: Cannot resolve the collation conflict between in the equal to operation

makumbi
 
on Nov 21, 2022 12:02 AM
328 Views

error

Msg 468, Level 16, State 9, Line 4
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.

 

SELECT        dbo.Tempshipadmno.admno, dbo.Tempshipadmno.Names, dbo.Tempshipadmno.Class, dbo.Tempshipadmno.Stream, dbo.Tempshipadmno.STdtype, dbo.Tempshipadmno.House, dbo.Tempshipadmno.Sex, 
                         dbo.Tempshipadmno.Status, 'Student' AS Type
FROM            dbo.Tempshipadmno LEFT OUTER JOIN
                         dbo.Accounts ON dbo.Tempshipadmno.admno = dbo.Accounts.Account 
WHERE        (dbo.Accounts.Account IS NULL)

 

Download FREE API for Word, Excel and PDF in ASP.Net: Download
dharmendr
 
on Nov 21, 2022 12:14 AM

Use default database collation in the WHERE clause.

SELECT        dbo.Tempshipadmno.admno, dbo.Tempshipadmno.Names, dbo.Tempshipadmno.Class, dbo.Tempshipadmno.Stream, dbo.Tempshipadmno.STdtype, dbo.Tempshipadmno.House, dbo.Tempshipadmno.Sex,
                         dbo.Tempshipadmno.Status, 'Student' AS Type
FROM            dbo.Tempshipadmno LEFT OUTER JOIN
                         dbo.Accounts ON dbo.Tempshipadmno.admno = dbo.Accounts.Account
WHERE        (dbo.Accounts.Account COLLATE DATABASE_DEFAULT IS NULL)