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.
UPDATEdbo.EB_DETAIL
SETdbo.EB_DETAIL.EBNumber = @EBNumber
FROM #EBCustomer t
INNER JOIN dbo.EB_DETAIL c
ON t.EBCode = c.EBCode COLLATE DATABASE_DEFAULT
WHEREc.EBNumber=0
Thanks.