SQL排序按 名称排序字母汉字混排

来源：百度知道 编辑：UC知道 时间：2024/07/02 00:26:40
我现有一字段值为
name
------------------------
BBB
CCC
阿阿
查查
AAA
拔拔
怎么样排序可以实现
name
--------------
AAA
阿阿
BBB
拔拔
CCC
查查

--首先准备一个拼音表
CREATE TABLE AWord(
PY varchar(10),
ZW nvarchar(10)
) ON [PRIMARY]
GO
--插入数据
insert into aword
select 'A',N'骜'
union all select 'B',N'簿'
union all select 'C',N'错'
union all select 'D',N'鵽'
union all select 'E',N'樲'
union all select 'F',N'鳆'
union all select 'G',N'腂'
union all select 'H',N'夻'
union all select 'J',N'攈'
union all select 'K',N'穒'
union all select 'L',N'鱳'
union all select 'M',N'旀'
union all select 'N',N'桛'
union all select 'O',N'沤'
union all select 'P',N'曝'
union all select 'Q',N'囕'
union all select 'R',N'鶸'
union all select 'S',N'蜶' <