摘要： CREATE TABLE #tb ( id INT IDENTITY , LocationName VARCHAR(24) , LocationIndex INT NULL )INSERT INTO #tb ( LocationName ) SELECT '1015-02A01' UNION SELECT '1015-01A01' UNION SELECT '1016-04A01' UNION SELECT '1016-05A01' UNION SELECT '1017-01A01' UNION SELECT &# 阅读全文