SQL Server 2008新功能 捕获数据变化（2） SQL Server 2008新功能 捕获数据变化(3)
【IT专家网独家】
第一步
先创建一个名为“MyDataBase“的数据库，如下所示(参见图Fig 1.0)：
| USE [master] GO /*** Object: Database [MyDataBase] Script Date: 01/07/2008 18:46:15 ***/ IF EXISTS (SELECT name FROM sys.databases WHERE name = N'MyDataBase') DROP DATABASE [MyDataBase] GO USE [master] GO /*** Object: Database [MyDataBase] Script Date: 01/07/2008 18:46:33 ***/ CREATE DATABASE [MyDataBase] GO |
第二步
在MyDataBase数据库中创建一个名为MyTable的表，如下所示(参见图Fig 1.1)：
| USE [MyDataBase] GO /*** Object: Table [dbo].[MyTable] Script Date: 01/07/2008 18:52:14 ***/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MyTable]') AND type in (N'U')) DROP TABLE [dbo].[MyTable] GO USE [MyDataBase] GO /*** Object: Table [dbo].[MyTable] Script Date: 01/07/2008 18:52:26 ***/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[MyTable]( [ID] [int] NOT NULL, [Name] [varchar](100) NULL, CONSTRAINT [MyTable_PK] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO |
