Microsoft® SQL Server® 2012 Bible

344

Part III: Advanced T-SQL Data Types and Querying Techniques

INSERT [dbo].[Item] ([ItemID], [ItemNumber], [ItemDescription])

VALUES (1, N'V001', N'Verizon Windows Phone 7')

INSERT [dbo].[Item] ([ItemID], [ItemNumber], [ItemDescription])

VALUES (2, N'A017', N'Alienware MX 17')

INSERT [dbo].[Item] ([ItemID], [ItemNumber], [ItemDescription])

VALUES (3, N'P002', N'Peters Pea Shooter 3000')

SET IDENTITY_INSERT [dbo].[Item] OFF

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

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Orders](

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

[CustomerID] [int] NOT NULL,

[OrderNumber] [nvarchar](50) NULL,

[OrderDate] [datetime] NULL,

CONSTRAINT [PK_Orders] PRIMARY KEY CLUSTERED

(

[OrderID] 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].[Orders] ON

INSERT [dbo].[Orders] ([OrderID], [CustomerID], [OrderNumber], [OrderDate])

VALUES (1, 1, N'10001', '6/15/2011')

INSERT [dbo].[Orders] ([OrderID], [CustomerID], [OrderNumber], [OrderDate])

VALUES (2, 2, N'10002', '6/16/2011')

INSERT [dbo].[Orders] ([OrderID], [CustomerID], [OrderNumber], [OrderDate])

VALUES (3, 1, N'10003', '6/17/2011')

INSERT [dbo].[Orders] ([OrderID], [CustomerID], [OrderNumber], [OrderDate])

VALUES (4, 2, N'10004', '6/18/2011')

SET IDENTITY_INSERT [dbo].[Orders] OFF

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

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[OrderDetail](

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

[OrderID] [int] NULL,

[ItemID] [int] NULL,

[Quantity] [int] NULL,

[Price] [money] NULL,

CONSTRAINT [PK_OrderDetail] PRIMARY KEY CLUSTERED

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

http://www.it-ebooks.info