34,838
社区成员




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