转自:http://blog.51cto.com/jimshu/1095780
概念与详情请参考:字符编码与排序规则:https://www.cnblogs.com/gered/p/9145123.html
零、修改表达式排序规则
问题1:
解决:
set @mdf=(SELECT dsize/1024 FROM #tf_driver a,db_tank..sysfiles b WHERE b.name='Db_Tank_Data' and a.driver COLLATE chinese_prc_ci_as =LEFT(b.FILENAME,1))set @ldf=(SELECT dsize/1024 FROM #tf_driver a,db_tank..sysfiles b WHERE b.name='Db_Tank_Log' and a.driver COLLATE chinese_prc_ci_as =LEFT(b.FILENAME,1))
问题2:
解决:见最后一行
select t1.name,t1.system_type_id,t1