对数据库中的项目符号进行排序 [英] Sort Bullets in Database

问题描述

我在数据库(SQL Server 2008)中有一个列[datatype:varchar(50)]，其值如下所示:

I have a column [datatype:varchar(50)] in database (SQL Server 2008) having Values as shown below:

1
2
1.1.11
4.1
5
2.1
1.1
4
1.2.1
4.2.2
4.3
4.2
4.3.1
4.2.1
11.2
1.2.4
4.4

这些是我记录的编号项目符号我需要将它们按顺序对所有记录进行分组 1,1.1,1.1.1,2,3.1,4,10.1,11.1....

these are numbered bullets for my records I need to sort them as grouping all the records in sequence 1,1.1,1.1.1,2,3.1,4,10.1,11.1....

请在这方面帮助我.

推荐答案

WITH T(YourColumn) AS
(
SELECT '1' UNION ALL
SELECT '2' UNION ALL
SELECT '1.1.11' UNION ALL
SELECT '4.1' UNION ALL
SELECT '5' UNION ALL
SELECT '2.1' UNION ALL
SELECT '1.1' UNION ALL
SELECT '4' UNION ALL
SELECT '1.2.1' UNION ALL
SELECT '4.2.2' UNION ALL
SELECT '4.3' UNION ALL
SELECT '4.2' UNION ALL
SELECT '4.3.1' UNION ALL
SELECT '4.2.1' UNION ALL
SELECT '11.2' UNION ALL
SELECT '1.2.4' UNION ALL
SELECT '4.4'
)
SELECT *
FROM T 
ORDER BY CAST('/' + YourColumn + '/' AS HIERARCHYID)

退货

YourColumn
----------
1
1.1
1.1.11
1.2.1
1.2.4
2
2.1
4
4.1
4.2
4.2.1
4.2.2
4.3
4.3.1
4.4
5
11.2

这是你需要的吗?

这篇关于对数据库中的项目符号进行排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！