插入测试数据
USE [sss]
CREATE TABLE TinyBlog(id INT  NULL，NAME VARCHAR(100))
ON [Sch_TinyBlog_Id](id)
SELECT * FROM TinyBlog ORDER BY id
INSERT INTO [dbo].[TinyBlog]
( [id]， [NAME] )
VALUES  ( NULL， -- id - int
'3232'  -- NAME - varchar(100)
)
INSERT INTO [dbo].[TinyBlog]
( [id]， [NAME] )
VALUES  ( -2， -- id - int
'-2'  -- NAME - varchar(100)
)
INSERT INTO [dbo].[TinyBlog]
( [id]， [NAME] )
VALUES  ( 66， -- id - int
'66'  -- NAME - varchar(100)
)
INSERT INTO [dbo].[TinyBlog]
( [id]， [NAME] )
VALUES  ( 0， -- id - int
'0'  -- NAME - varchar(100)
)
INSERT INTO [dbo].[TinyBlog]
( [id]， [NAME] )
VALUES  ( -30， -- id - int
'-30'  -- NAME - varchar(100)
)
　　表数据如下
　　SELECT * FROM TinyBlog ORDER BY id

　　分区分布
　　--查看分区架构文件组分布
SELECT  CONVERT(VARCHAR(MAX)， ps.name) AS partition_scheme ，
p.partition_number ，
CONVERT(VARCHAR(MAX)， ds2.name) AS filegroup ，
CONVERT(VARCHAR(MAX)， ISNULL(v.value， '')， 120) AS range_boundary ，
STR(p.rows， 9) AS rows
FROM    sys.indexes i
JOIN sys.partition_schemes ps ON i.data_space_id = ps.data_space_id
JOIN sys.destination_data_spaces dds ON ps.data_space_id = dds.partition_scheme_id
JOIN sys.data_spaces ds2 ON dds.data_space_id = ds2.data_space_id
JOIN sys.partitions p ON dds.destination_id = p.partition_number
AND p.object_id = i.object_id
AND p.index_id = i.index_id
JOIN sys.partition_functions pf ON ps.function_id = pf.function_id
LEFT JOIN sys.Partition_Range_values v ON pf.function_id = v.function_id
AND v.boundary_id = p.partition_number
- pf.boundary_value_on_right
WHERE   i.object_id = OBJECT_ID('TinyBlog')
AND i.index_id IN ( 0， 1 )
ORDER BY p.partition_number
--分区区间
--SELECT  *  FROM    sys.partition_range_values