How to works COLLATE DATABASE_DEFAULT?

• Leo-696352

  SSCrazy

  Points: 2708

  More actions

  October 15, 2008 at 6:56 am

  #194652

  Hi Guys,

  I just wondering what is the better way to replace 'COLLATE' or Some way we can declare it somewhere before we do on update statement. Because I have another 3 more similar UPDATE after that process and all in one store procedure, the same thing using with 'COLLATE', but those process are take so slow. Anyway can we improve this.

  UPDATE dbo.EB_DETAIL

  SET dbo.EB_DETAIL.EBNumber = @EBNumber

  FROM #EBCustomer t

  INNER JOIN dbo.EB_DETAIL c

  ON t.EBCode = c.EBCode COLLATE DATABASE_DEFAULT

  WHERE c.EBNumber=0

  Thanks.

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  October 15, 2008 at 11:25 am

  #885373

  Did you try

  ALTER DATABASE ... -- for database level

  ALTER TABLE ... -- for table levle