SQL Federation 实验

第一步，创建表

CREATE DATABASE SalesDB
GO

第二步，连接到SalesDB，创建Federation
--

CREATE FEDERATION CustomerFederation(cid BIGINT RANGE)
GO
-- Connect to the federation member
USE FEDERATION CustomerFederation(cid = 0) WITH FILTERING=OFF, RESET
GO
CREATE TABLE [dbo].[Customer](
	[CustomerID] [bigint] NOT NULL,
	[Title] [nvarchar](18) NULL
 CONSTRAINT [PK_Customer] PRIMARY KEY CLUSTERED ([CustomerID] ASC) 
) FEDERATED ON (cid = CustomerID)
GO
CREATE TABLE [dbo].[CustomerAddress](
	[AddressID] [int] NOT NULL,
	[CustomerID] [bigint] NOT NULL,
	[AddressName]  [nvarchar](80) NULL
 	CONSTRAINT [PK_CustomerAddress] PRIMARY KEY CLUSTERED ([CustomerID],[AddressID] ASC)
) FEDERATED ON (cid = CustomerID)
GO
CREATE TABLE [dbo].[PostalCode](
	[PostalCodeID] [int] NOT NULL,
	[PostalCode] [nvarchar](15) NOT NULL
	 CONSTRAINT [PK_PostalCode] PRIMARY KEY CLUSTERED ([P