????SQL Server?????????range?????????????????????????????????
???????MySQL???????????????RANGE??????LIST??????HASH??????KEY???????????????????????????Щ??
???????????MySQL??SQL Server??з???????????????????з??????????????д???NULL?
??????????????SQL Server???????????е?NULL???????NULL???????????????????????????
???????????
--1.?????????
ALTER DATABASE [sss]
ADD FILEGROUP [FG_TinyBlog_Id_01]
ALTER DATABASE [sss]
ADD FILEGROUP [FG_TinyBlog_Id_02]
ALTER DATABASE [sss]
ADD FILEGROUP [FG_TinyBlog_Id_03]
ALTER DATABASE [sss]
ADD FILEGROUP [FG_TinyBlog_Id_04]
ALTER DATABASE [sss]
ADD FILEGROUP [FG_TinyBlog_Id_05]
--2.???????
ALTER DATABASE [sss]
ADD FILE
(NAME = N'FG_TinyBlog_Id_01_data'??FILENAME = N'E:DataBasesssFG_TinyBlog_Id_01_data.ndf'??SIZE = 96MB?? FILEGROWTH = 24MB )
TO FILEGROUP [FG_TinyBlog_Id_01];
ALTER DATABASE [sss]
ADD FILE
(NAME = N'FG_TinyBlog_Id_02_data'??FILENAME = N'E:DataBasesssFG_TinyBlog_Id_02_data.ndf'??SIZE = 96MB?? FILEGROWTH = 24MB )
TO FILEGROUP [FG_TinyBlog_Id_02];
ALTER DATABASE [sss]
ADD FILE
(NAME = N'FG_TinyBlog_Id_03_data'??FILENAME = N'E:DataBasesssFG_TinyBlog_Id_03_data.ndf'??SIZE = 96MB?? FILEGROWTH = 24MB )
TO FILEGROUP [FG_TinyBlog_Id_03];
ALTER DATABASE [sss]
ADD FILE
(NAME = N'FG_TinyBlog_Id_04_data'??FILENAME = N'E:DataBasesssFG_TinyBlog_Id_04_data.ndf'??SIZE = 96MB?? FILEGROWTH = 24MB )
TO FILEGROUP [FG_TinyBlog_Id_04];
ALTER DATABASE [sss]
ADD FILE
(NAME = N'FG_TinyBlog_Id_05_data'??FILENAME = N'E:DataBasesssFG_TinyBlog_Id_05_data.ndf'??SIZE = 96MB?? FILEGROWTH = 24MB )
TO FILEGROUP [FG_TinyBlog_Id_05];
--3.????????????
CREATE PARTITION FUNCTION
Fun_TinyBlog_Id(INT) AS
RANGE LEFT
FOR VALUES(-10??0??1??6)
--4.????????????
CREATE PARTITION SCHEME
[Sch_TinyBlog_Id] AS
PARTITION [Fun_TinyBlog_Id]
TO([FG_TinyBlog_Id_01]??[FG_TinyBlog_Id_02]??[FG_TinyBlog_Id_03]??[FG_TinyBlog_Id_04]??[FG_TinyBlog_Id_05])