小弟在Enterprise Manager 內執行段Update Sql , 出現了一段奇怪的錯誤訊息, 如下 請問這是什麼原因告成的? Cannot resolve the collation conflict between "Chinese_Taiwan_Stroke_90_CI_AS" and "Chinese_Taiwan_Stroke_CI_AS" in the equal to operation. --------------------------------------------------------------- 我的Update Sql: Update [Checks] set E01=1 WHERE ((E01=0) or (E01 IS NULL)) AND ([Checks].GradeID=7) and (Years=88) and (Select dbo.funS0ID(Sight.Sight0L, Sight.Sight0R) from Sight where Sight.PID=[Checks].PID and Sight.GradeID=[Checks].GradeID and Sight.Sem=2)<>1

http://www.588188.com/netbook/sqlserver2000/tsqlref/ts_da-db_7ory.htm ---------------------------- 於Delphi K.Top之上 博采眾家之長, 奉獻綿薄之力 ---------------------------

------
------------------------
博采眾家之長,奉獻綿薄之力
------------------------

Thanks, 但您所附的連結無法瀏覽

引言: http://www.588188.com/netbook/sqlserver2000/tsqlref/ts_da-db_7ory.htm ---------------------------- 於Delphi K.Top之上 博采眾家之長, 奉獻綿薄之力 ---------------------------

Hi will 您好 試試將最後的<>1去掉，然後將＝改成<> (Select dbo.funS0ID(Sight.Sight0L, Sight.Sight0R) from Sight where Sight.PID<>[Checks].PID and Sight.GradeID<>[Checks].GradeID and Sight.Sem<>2)

請檢查 1. Sight.PID 跟 [Checks].PID 的定序是否相同 2. Sight.GradeID 跟 [Checks].GradeID 的定序是否相同 當欄位定序不相同時，不可以用來比較 欄位定序可以從設計資料表的畫面得知及修改 加油喔，喵～

------
歡迎參訪 "腦殘賤貓的備忘錄" http://maolaoda.blogspot.com/