CREATE PARTITION FUNCTION funcName( varchar)
AS RANGE LEFT
FOR VALUES (‘abc01’,’sbd02’)
uj5u.com熱心網友回復：
E.g.: If it ensures primary file group contains all records of the table. Now you are going to split the table into 2 partitions. You can use the following syntax:CREATE PARTITION FUNCTION PF_Tbl_3rdParatition(NUMERIC(18,0)) AS RANGE LEFT
FOR VALUES(500);
CREATE PARTITION SCHEME PS_Tbl_3rdParatition AS PARTITION PF_Tbl_3rdParatition TO ([PRIMARY],[SWPPartitionFG1])
CREATE UNIQUE CLUSTERED INDEX CidxTbl_3rdParatition ON dbo.Tbl_3rdParatition(PK) WITH(DROP_EXISTING = ON)ON PS_Tbl_3rdParatition(PK) ;
Partition1 stored in SWPPartitionFG1
uj5u.com熱心網友回復：
磁區函式的值，一般用 DATETIME ， int 型應該也可以。雜亂無章的值沒有辦法作為磁區函式的值，因為這樣的話 sqlserver 無法界定磁區的邊界。
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/68044.html
標籤：疑難問題
上一篇：求助！！！筆記本連不了網，wifi圖示那里是一個地球
下一篇：求教如何備份資料庫！！！！！