如何利用SQL Server 2005分布式分区视图分解数据表

ServerA:

IF OBJECT_ID('SalesHistory','U') > 0      

DROP TABLE SalesHistory

GO

CREATE TABLE SalesHistory

(            
      SaleID INT PRIMARY KEY,            
      Product VARCHAR(30) NOT NULL,             
      SaleDate DATETIME,             
      SalePrice MONEY, 
      Region VARCHAR(5) NOT NULL, 
      CONSTRAINT chk_Region CHECK (SaleID <20000)

)

GO



DECLARE @i SMALLINT, @Region VARCHAR(5)

SET @i = 1

SET @Region = 'West'



WHILE (@i <=6000)

BEGIN            
      INSERT INTO SalesHistory         
      (SaleID, Product, SaleDate, SalePrice, Region)            
      VALUES      

(@i, 'Computer', DATEADD(mm, @i, '3/11/1919'), DATEPART(ms, GETDATE()) + (@i + 57), @Region )
      SET @i = @i + 1
      INSERT INTO SalesHistory            
      (SaleID, Product, SaleDate, SalePrice, Region)
      VALUES      
       (@i, 'BigScreen', DATEADD(mm, @i, '3/11/1927'), DATEPART(ms, GETDATE()) + (@i + 13), @Region)            
      SET @i = @i + 1
      INSERT INTO SalesHistory            
      (SaleID, Product, SaleDate, SalePrice, Region)    
      VALUES      
      (@i, 'PoolTable', DATEADD(mm, @i, '3/11/1908'), DATEPART(ms, GETDATE()) + (@i + 29), @Region )            
      SET @i = @i + 1

END


ServerB:

IF OBJECT_ID('SalesHistory','U') > 0      

DROP TABLE SalesHistory

GO

CREATE TABLE SalesHistory

(            
      SaleID INT PRIMARY KEY,            
      Product VARCHAR(30) NOT NULL,             
      SaleDate DATETIME,             
      SalePrice MONEY, 
      Region VARCHAR(5) NOT NULL, 
      CONSTRAINT chk_Region CHECK (SaleID >=20000)

)

GO



DECLARE @i SMALLINT, @Region VARCHAR(5)

SET @i = 20000

SET @Region = 'East'



WHILE (@i <=26000)

BEGIN            
      INSERT INTO SalesHistory         
      (SaleID, Product, SaleDate, SalePrice, Region)            
      VALUES      
      (@i, 'Computer', DATEADD(mm, @i, '3/11/1919'), DATEPART(ms, GETDATE()) + (@i + 57), @Region )
      SET @i = @i + 1
      INSERT INTO SalesHistory            
      (SaleID, Product, SaleDate, SalePrice, Region)
      VALUES      
      (@i, 'BigScreen', DATEADD(mm, @i, '3/11/1927'), DATEPART(ms, GETDATE()) + (@i + 13), @Region)            
      SET @i = @i + 1
      INSERT INTO SalesHistory            
      (SaleID, Product, SaleDate, SalePrice, Region)    
      VALUES      
       (@i, 'PoolTable', DATEADD(mm, @i, '3/11/1908'), DATEPART(ms, GETDATE()) + (@i + 29), @Region )            
      SET @i = @i + 1

END