無法解析equal to 作業中"Latin1_General_CI_AI" 與"Chinese_Taiwan_Stroke_CI_AS" 之間的定序衝突
解法很簡單只要將定序不統一的欄位用COLLAPE轉換就可以了:假使你資料庫的定序是"Chinese_Taiwan_Stroke_CI_AS",則只要不是該定序的全把它轉回來就好了。
範例如下:
select *
from tmpa as a left join tmpb as b
on (a.entrid COLLATE Chinese_Taiwan_Stroke_CI_AS)=b.empyno
left join tmpb as c
on (a.updaid COLLATE Chinese_Taiwan_Stroke_CI_AS)=c.empyno
order by a.fundcd
沒有留言:
張貼留言