July 5, 2004 at 2:18 am
Can any one help me
on partitioning table @ sql server 2000.
I knew that oracle support partitioning table as follows:
CREATE TABLE My_table
(
Id varchar(15) not null,
…….
SavingBalace number(12,3) Default 0 not null
…
)
partition by Ranage(Saving_Balance)
(
partition BR_Save_part1 Values Less Than (50000) Tablespace ts_cb_1,
partition BR_Save_part2 Values Less Than (100000) Tablespace ts_cb_2,
partition BR_Save_part3 Values Less Than (150000) Tablespace ts_cb_3,
partition BR_Save_part4 Values Less Than (MAXVALUE) Tablespace ts_cb_5
)
Enable ROW MOVEMENT
;
Is it possible for sql server 2000?
..Better Than Before...
July 5, 2004 at 10:35 pm
I believe this functionality will be released in the next version of SQL Server.
May 6, 2005 at 10:14 am
SQL Server 2000 does support partitioning, but not in the Oracle sense (yet).
In SQL Server partitioning consists of one table for every partition, a check constraint (OBS be sure to NOT create the constraint with the NOCHECK option) that guarantees the partitioned data to be in the correct partition.
'Over' these partitions you must create a UNION ALL view ex:
CREATE VIEW myView AS
SELECT Col1, Col2 FROM Part1
UNION ALL
SELECT Col1, Col2 FROM Part2
UNION ALL
SELECT Col1, Col2 FROM Part3
Good luck, Hanslindgren!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply