--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
--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