Microsoft® SQL Server® 2012 Bible

343

Chapter 14: Using XML Data

14

GO

CREATE TABLE [dbo].[Customer](

[CustomerID] [int] IDENTITY(1,1) NOT NULL,

[Name] [nvarchar](50) NULL,

[Address] [nvarchar](50) NULL,

[City] [nvarchar](50) NULL,

[State] [nvarchar](50) NULL,

[ZipCode] [nvarchar](50) NULL,

[Phone] [nvarchar](50) NULL,

CONSTRAINT [PK_Customer] PRIMARY KEY CLUSTERED

(

[CustomerID] 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 IDENTITY_INSERT [dbo].[Customer] ON

INSERT [dbo].[Customer] ([CustomerID], [Name], [Address], [City], [State],

[ZipCode], [Phone])

VALUES (1, N'Scott', N'555 Main St.', N'Palm Beach', N'FL', N'33333', N'555-555-

5555')

INSERT [dbo].[Customer] ([CustomerID], [Name], [Address], [City], [State],

[ZipCode], [Phone])

VALUES (2, N'Adam', N'111 Works St.', N'Jax', N'FL', N'34343', N'444-444-4444')

INSERT [dbo].[Customer] ([CustomerID], [Name], [Address], [City], [State],

[ZipCode], [Phone])

VALUES (3, N'John', N'123 Pike Blvd', N'Seattle', N'WA', N'98989', N'999-999-

9999')

SET IDENTITY_INSERT [dbo].[Customer] OFF

/****** Object: Table [dbo].[Item] ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Item](

[ItemID] [int] IDENTITY(1,1) NOT NULL,

[ItemNumber] [nvarchar](50) NULL,

[ItemDescription] [nvarchar](50) NULL,

CONSTRAINT [PK_Item] PRIMARY KEY CLUSTERED

(

[ItemID] 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 IDENTITY_INSERT [dbo].[Item] ON

c14.indd 343c14.indd 343 7/30/2012 4:49:00 PM7/30/2012 4:49:00 PM

http://www.it-ebooks.info