根据汉子首字母排序,

--1. 按拼音排序
DECLARE @t TABLE(col varchar(2))
INSERT @t SELECT '中'
UNION ALL SELECT '国'
UNION ALL SELECT '家'
UNION ALL SELECT '人'
UNION ALL SELECT '郭'

SELECT * FROM @t 
ORDER BY col COLLATE Chinese_PRC_CS_AS_KS_WS

原文地址:https://www.cnblogs.com/accumulater/p/6145369.html