try:
1、
select * from member where member_id between 0 and 1000
2、
select * from member where member_id<50000 and member<1000
1、
select * from member where member_id between 0 and 1000
2、
select * from member where member_id<50000 and member<1000
你去看看分区视图的规格吧!难道不能满足check约束,数据能加入到表中???
CREATE TABLE [dbo].[member_1] (
[member_id] [int] NOT NULL
CHECK ([member_id] >= 1 AND [member_id] <= 50000)
)
ALTER TABLE [member_1] ADD PRIMARY KEY ([member_id])CREATE TABLE [dbo].[member_2] (
[member_id] [int] NOT NULL
CHECK (([member_id] >= 50001 AND [member_id] <= 100000)
ALTER TABLE [member_2] ADD PRIMARY KEY ([member_id])