select a.*,c.DataName MemberLevelName,e.CouponNum,e.OrderTotalNum,e.OrderToDoNum,
e.OrderToPayNum,e.ContractNum,b.MemberCardCode,g.EntAgrmtCode,g.EnterpriseName,
b.CommercialCode ftpEntAgrmtCode,h.EnterpriseName ftpEnterpriseName,
case b.Country when 1 then convert(varchar(500),f.DataName)
when 2 then convert(varchar(500),b.OtherCountry)
end WebMemberCountryName
from avisWebMember a
f.DataName varchar(50)
b.OtherCountry varchar(255)
错误信息如下消息 457,级别 16,状态 1,第 2 行
无法执行 varchar 值到 varchar 的隐式转换,原因是,由于排序规则冲突,该值的排序规则未经解析。请大家指点。在线等。
e.OrderToPayNum,e.ContractNum,b.MemberCardCode,g.EntAgrmtCode,g.EnterpriseName,
b.CommercialCode ftpEntAgrmtCode,h.EnterpriseName ftpEnterpriseName,
case b.Country
when 1 then convert(varchar(500),f.DataName collate Chinese_PRC_AS_CS)
when 2 then convert(varchar(500),b.OtherCountry collate Chinese_PRC_AS_CS)
end WebMemberCountryName
from avisWebMember a这样呢
e.OrderToPayNum,e.ContractNum,b.MemberCardCode,g.EntAgrmtCode,g.EnterpriseName,
b.CommercialCode ftpEntAgrmtCode,h.EnterpriseName ftpEnterpriseName,
case b.Country
when 1 then convert(varchar(500),f.DataName collate Chinese_PRC_CI_AS)
when 2 then convert(varchar(500),b.OtherCountry collate Chinese_PRC_CI_AS)
end WebMemberCountryName
from avisWebMember a改一下。
when 2 then convert(varchar(500), b.OtherCountry COLLATE DATABASE_DEFAULT)
end WebMemberCountryName
经过群里几位老大指点,出来了。谢谢 htl258