Post reply

Different collation dbs .. except

  • February 18, 2013 at 11:19 am

    #274282

    DB1 - COLLATION - SQL_Latin1_General_CP1_CS_AS

    DB2 - - COLLATION - SQL_Latin1_General_CP1_CI_AS

    SELECT * FROM DB1.dbo.Table1

    EXCEPT

    SELECT * FROM DB2.dbo.Table2

    Query failing - any workaround?

    thx

  • February 18, 2013 at 11:43 am

    #1588933

    Explicitly declare each column in the select lists and for those columns that are defined as chaacter values include COLLATION and which collation you want to use for the comparision. It needs to be the same on each side of the EXCEPT operator.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply