34,590
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM 表名 ORDER BY A collate Chinese_PRC_BIN
DECLARE @local_variable Table (A varchar(40) COLLATE Chinese_PRC_BIN)
INSERT INTo @local_variable
select '1101' A
UNION ALL SELECT '1102'
UNION ALL SELECT '1103'
UNION ALL SELECT '1-1101'
UNION ALL SELECT '1-1102'
UNION ALL SELECT '1-1103'
order by A
SELECT * FROM @local_variable