Chào các bạn! Vì nhiều lý do từ nay Truyen2U chính thức đổi tên là Truyen247.Pro. Mong các bạn tiếp tục ủng hộ truy cập tên miền mới này nhé! Mãi yêu... ♥
  1. Home
  2. /
  3. Ngẫu Nhiên
  4. /
  5. USE [TestDB]
  6. /
  7. USE [TestDB]

USE [TestDB]

Trước Sau

USE [TestDB]

GO

/****** Object:  Table [dbo].[CUSTORDERS]    Script Date: 11/04/2011 13:37:48 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[CUSTORDERS](

 [ID] [char](36) NOT NULL,

 [ORDERNO] [nvarchar](50) NULL,

 [ORDERDATE] [date] NULL,

 [CUSTOMER] [nvarchar](255) NULL,

 [ADDRESS] [nvarchar](255) NULL,

 [TELNO] [nvarchar](50) NULL,

 [INVOICENO] [nvarchar](50) NULL,

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

INSERT [dbo].[CUSTORDERS] ([ID], [ORDERNO], [ORDERDATE], [CUSTOMER], [ADDRESS], [TELNO], [INVOICENO]) VALUES (N'1085EFB0-7B1C-4B6F-86D6-EAE9EFCEAFDD', N'HD00005_20110905', CAST(0xB4340B00 AS Date), N'Lý Nhã Kỳ', N'227 Nguyễn Tri Phương, Q10, TP.HCM', N'0916171819', N'5')

INSERT [dbo].[CUSTORDERS] ([ID], [ORDERNO], [ORDERDATE], [CUSTOMER], [ADDRESS], [TELNO], [INVOICENO]) VALUES (N'2B0016D8-193E-4A9B-8AB6-B3BB307B6CF2', N'HD00004_20110905', CAST(0xB4340B00 AS Date), N'Ôn Bích Hà', N'59C Nguyễn Đình Chiểu Q3, TP.HCM', N'0906070809', N'3')

INSERT [dbo].[CUSTORDERS] ([ID], [ORDERNO], [ORDERDATE], [CUSTOMER], [ADDRESS], [TELNO], [INVOICENO]) VALUES (N'572DE3D5-6019-430F-A44C-A6C8653F2056', N'HD00001_20110905', CAST(0xB4340B00 AS Date), N'Trương Mạn Ngọc', N'139 Pasteur, Q3, TP.HCM', N'0909090909', N'1')

INSERT [dbo].[CUSTORDERS] ([ID], [ORDERNO], [ORDERDATE], [CUSTOMER], [ADDRESS], [TELNO], [INVOICENO]) VALUES (N'62CCA0FC-D86E-4F98-9DBC-BEB55B0201ED', N'HD00010_20110905', CAST(0xB4340B00 AS Date), N'Lưu Diệt Phi', N'8888 Trần ưng Đạo, Q1, TP.HCM', N'0937363534', N'4')

INSERT [dbo].[CUSTORDERS] ([ID], [ORDERNO], [ORDERDATE], [CUSTOMER], [ADDRESS], [TELNO], [INVOICENO]) VALUES (N'A4E11A81-F9BD-4DA5-84B0-1326C0C6EABD', N'HD00008_20110905', CAST(0xB4340B00 AS Date), N'Phạm Băng Băng', N'9999 Nguyễn Thị Minh Khai TP.HCM', N'0986212121', N'8')

INSERT [dbo].[CUSTORDERS] ([ID], [ORDERNO], [ORDERDATE], [CUSTOMER], [ADDRESS], [TELNO], [INVOICENO]) VALUES (N'A518CE9D-A63B-4030-B721-5C398CC29980', N'HD00002_20110905', CAST(0xB4340B00 AS Date), N'Dương Tử Quỳnh', N'987 Hai Bà Trưng, Q3, TP.HCM', N'0985428842', N'2')

INSERT [dbo].[CUSTORDERS] ([ID], [ORDERNO], [ORDERDATE], [CUSTOMER], [ADDRESS], [TELNO], [INVOICENO]) VALUES (N'C06F8224-7C9C-484E-96D4-8BB31FA9C031', N'HD00006_20110905', CAST(0xB4340B00 AS Date), N'Lý Gia Hân', N'97 Nam Kỳ Khởi Nghĩa, Q3, TP.HCM', N'0981828388', N'6')

INSERT [dbo].[CUSTORDERS] ([ID], [ORDERNO], [ORDERDATE], [CUSTOMER], [ADDRESS], [TELNO], [INVOICENO]) VALUES (N'F5EEF73A-E89C-4159-8F2F-5DD093D97331', N'HD00007_20110905', CAST(0xB4340B00 AS Date), N'Trương Huệ Muội', N'10 Lý Tự Trọng, Q1, TP.HCM', N'0937373737', N'7')

INSERT [dbo].[CUSTORDERS] ([ID], [ORDERNO], [ORDERDATE], [CUSTOMER], [ADDRESS], [TELNO], [INVOICENO]) VALUES (N'F69768C5-154B-49DD-AC22-B3217D599B4D', N'HD00003_20110905', CAST(0xB4340B00 AS Date), N'Trác Y Đình', N'279 Nguyễn Văn Cừ, Q5, TP.HCM', N'0972737475', N'3')

INSERT [dbo].[CUSTORDERS] ([ID], [ORDERNO], [ORDERDATE], [CUSTOMER], [ADDRESS], [TELNO], [INVOICENO]) VALUES (N'FDB7F4D8-B198-49DC-A02D-0A484C2AB7D0', N'HD00009_20110905', CAST(0xB4340B00 AS Date), N'Phạm Vỹ Kỳ', N'7777 Nguyễn Đình Chiểu, Q3, TP.HCM', N'0909979899', N'9')

/****** Object:  Table [dbo].[CUSTORDERDETAILS]    Script Date: 11/04/2011 13:37:48 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[CUSTORDERDETAILS](

 [ORDERID] [char](36) NOT NULL,

 [PRODUCTID] [char](36) NOT NULL,

 [UNITPRICE] [float] NULL,

 [QUANTITY] [int] NULL,

 [DISCOUNTPER] [float] NULL,

 [VAT] [float] NULL,

 CONSTRAINT [PK_CUSTORDERDETAILS] PRIMARY KEY CLUSTERED

(

 [ORDERID] ASC,

 [PRODUCTID] 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

INSERT [dbo].[CUSTORDERDETAILS] ([ORDERID], [PRODUCTID], [UNITPRICE], [QUANTITY], [DISCOUNTPER], [VAT]) VALUES (N'A4E11A81-F9BD-4DA5-84B0-1326C0C6EABD', N'7A34B04D-332B-43CB-8252-8EB207FB5079', 5000000, 50, 10, 10)

INSERT [dbo].[CUSTORDERDETAILS] ([ORDERID], [PRODUCTID], [UNITPRICE], [QUANTITY], [DISCOUNTPER], [VAT]) VALUES (N'A4E11A81-F9BD-4DA5-84B0-1326C0C6EABD', N'7EF602D1-C938-4FEE-9058-5C8EEED295F8', 7000000, 30, 10, 10)

INSERT [dbo].[CUSTORDERDETAILS] ([ORDERID], [PRODUCTID], [UNITPRICE], [QUANTITY], [DISCOUNTPER], [VAT]) VALUES (N'A4E11A81-F9BD-4DA5-84B0-1326C0C6EABD', N'965ADA27-581E-4AB6-BD5E-866A2674F8C5', 3000000, 40, 10, 10)

INSERT [dbo].[CUSTORDERDETAILS] ([ORDERID], [PRODUCTID], [UNITPRICE], [QUANTITY], [DISCOUNTPER], [VAT]) VALUES (N'A4E11A81-F9BD-4DA5-84B0-1326C0C6EABD', N'9E5F8B55-F038-4C8E-88F8-C9BAF4D6DA66', 2000000, 70, 10, 10)

INSERT [dbo].[CUSTORDERDETAILS] ([ORDERID], [PRODUCTID], [UNITPRICE], [QUANTITY], [DISCOUNTPER], [VAT]) VALUES (N'A4E11A81-F9BD-4DA5-84B0-1326C0C6EABD', N'B1384A78-03B8-4FBD-8060-BE5176CDCCC3', 5000000, 60, 10, 10)

INSERT [dbo].[CUSTORDERDETAILS] ([ORDERID], [PRODUCTID], [UNITPRICE], [QUANTITY], [DISCOUNTPER], [VAT]) VALUES (N'A518CE9D-A63B-4030-B721-5C398CC29980', N'7A34B04D-332B-43CB-8252-8EB207FB5079', 1000000, 20, 10, 10)

INSERT [dbo].[CUSTORDERDETAILS] ([ORDERID], [PRODUCTID], [UNITPRICE], [QUANTITY], [DISCOUNTPER], [VAT]) VALUES (N'A518CE9D-A63B-4030-B721-5C398CC29980', N'7EF602D1-C938-4FEE-9058-5C8EEED295F8', 4000000, 40, 10, 10)

INSERT [dbo].[CUSTORDERDETAILS] ([ORDERID], [PRODUCTID], [UNITPRICE], [QUANTITY], [DISCOUNTPER], [VAT]) VALUES (N'A518CE9D-A63B-4030-B721-5C398CC29980', N'965ADA27-581E-4AB6-BD5E-866A2674F8C5', 7000000, 30, 10, 10)

INSERT [dbo].[CUSTORDERDETAILS] ([ORDERID], [PRODUCTID], [UNITPRICE], [QUANTITY], [DISCOUNTPER], [VAT]) VALUES (N'A518CE9D-A63B-4030-B721-5C398CC29980', N'9E5F8B55-F038-4C8E-88F8-C9BAF4D6DA66', 5000000, 20, 10, 10)

INSERT [dbo].[CUSTORDERDETAILS] ([ORDERID], [PRODUCTID], [UNITPRICE], [QUANTITY], [DISCOUNTPER], [VAT]) VALUES (N'A518CE9D-A63B-4030-B721-5C398CC29980', N'B1384A78-03B8-4FBD-8060-BE5176CDCCC3', 7000000, 10, 10, 10)

INSERT [dbo].[CUSTORDERDETAILS] ([ORDERID], [PRODUCTID], [UNITPRICE], [QUANTITY], [DISCOUNTPER], [VAT]) VALUES (N'FDB7F4D8-B198-49DC-A02D-0A484C2AB7D0', N'7A34B04D-332B-43CB-8252-8EB207FB5079', 7000000, 30, 10, 10)

INSERT [dbo].[CUSTORDERDETAILS] ([ORDERID], [PRODUCTID], [UNITPRICE], [QUANTITY], [DISCOUNTPER], [VAT]) VALUES (N'FDB7F4D8-B198-49DC-A02D-0A484C2AB7D0', N'7EF602D1-C938-4FEE-9058-5C8EEED295F8', 3000000, 10, 10, 10)

INSERT [dbo].[CUSTORDERDETAILS] ([ORDERID], [PRODUCTID], [UNITPRICE], [QUANTITY], [DISCOUNTPER], [VAT]) VALUES (N'FDB7F4D8-B198-49DC-A02D-0A484C2AB7D0', N'965ADA27-581E-4AB6-BD5E-866A2674F8C5', 4000000, 20, 10, 10)

INSERT [dbo].[CUSTORDERDETAILS] ([ORDERID], [PRODUCTID], [UNITPRICE], [QUANTITY], [DISCOUNTPER], [VAT]) VALUES (N'FDB7F4D8-B198-49DC-A02D-0A484C2AB7D0', N'9E5F8B55-F038-4C8E-88F8-C9BAF4D6DA66', 5000000, 20, 10, 10)

INSERT [dbo].[CUSTORDERDETAILS] ([ORDERID], [PRODUCTID], [UNITPRICE], [QUANTITY], [DISCOUNTPER], [VAT]) VALUES (N'FDB7F4D8-B198-49DC-A02D-0A484C2AB7D0', N'B1384A78-03B8-4FBD-8060-BE5176CDCCC3', 2000000, 10, 10, 10)

/****** Object:  Table [dbo].[PRODUCTS]    Script Date: 11/04/2011 13:37:48 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[PRODUCTS](

 [PRODUCTID] [char](36) NOT NULL,

 [PRODUCTCODE] [nvarchar](50) NULL,

 [PRODUCTNAME] [nvarchar](255) NULL,

 [PRODUCTLINE] [nvarchar](50) NULL,

PRIMARY KEY CLUSTERED

(

 [PRODUCTID] 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

INSERT [dbo].[PRODUCTS] ([PRODUCTID], [PRODUCTCODE], [PRODUCTNAME], [PRODUCTLINE]) VALUES (N'427F75DE-1A53-4708-9BD5-8681F691CBF0', N'P0007', N'Máy xoay sinh tố', N'Đời đầu')

INSERT [dbo].[PRODUCTS] ([PRODUCTID], [PRODUCTCODE], [PRODUCTNAME], [PRODUCTLINE]) VALUES (N'646FFFDF-DE66-494E-BFB7-82BD280621EC', N'P0006', N'Máy lạnh Hitachi', N'Đời đầu')

INSERT [dbo].[PRODUCTS] ([PRODUCTID], [PRODUCTCODE], [PRODUCTNAME], [PRODUCTLINE]) VALUES (N'7A34B04D-332B-43CB-8252-8EB207FB5079', N'P0003', N'Máy hút bụi Toshiba', N'Đời đầu')

INSERT [dbo].[PRODUCTS] ([PRODUCTID], [PRODUCTCODE], [PRODUCTNAME], [PRODUCTLINE]) VALUES (N'7EF602D1-C938-4FEE-9058-5C8EEED295F8', N'P0004', N'Máy nước nóng Alaska', N'Đời đầu')

INSERT [dbo].[PRODUCTS] ([PRODUCTID], [PRODUCTCODE], [PRODUCTNAME], [PRODUCTLINE]) VALUES (N'965ADA27-581E-4AB6-BD5E-866A2674F8C5', N'P0005', N'Máy xén cỏ Electrolux', N'Đời đầu')

INSERT [dbo].[PRODUCTS] ([PRODUCTID], [PRODUCTCODE], [PRODUCTNAME], [PRODUCTLINE]) VALUES (N'9E5F8B55-F038-4C8E-88F8-C9BAF4D6DA66', N'P0001', N'Máy giặt Electrolux', N'Đời đầu 1')

INSERT [dbo].[PRODUCTS] ([PRODUCTID], [PRODUCTCODE], [PRODUCTNAME], [PRODUCTLINE]) VALUES (N'A270518D-6631-4516-B479-7E2BA717A32C', N'P0010SDF', N'Máy tập tạ', N'Đời sau')

INSERT [dbo].[PRODUCTS] ([PRODUCTID], [PRODUCTCODE], [PRODUCTNAME], [PRODUCTLINE]) VALUES (N'B1384A78-03B8-4FBD-8060-BE5176CDCCC3', N'P0002', N'Máy rửa chén Alaska', N'Đời nhì')

INSERT [dbo].[PRODUCTS] ([PRODUCTID], [PRODUCTCODE], [PRODUCTNAME], [PRODUCTLINE]) VALUES (N'E2D6EB6B-7855-4EB4-BAFA-5C0F20103020', N'P0010', N'Máy tập tạ', N'Đời sau')

/****** Object:  StoredProcedure [dbo].[PRODUCT_UPDATE]    Script Date: 11/04/2011 13:37:44 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[PRODUCT_UPDATE]

 -- Add the parameters for the stored procedure here

 @PROID CHAR(36),

 @PROCODE NVARCHAR(50),

 @PRONAME NVARCHAR(50),

 @PROLINE NVARCHAR(50)

AS

BEGIN

 -- SET NOCOUNT ON added to prevent extra result sets from

 -- interfering with SELECT statements.

 SET NOCOUNT ON;

 begin try

 IF @PROCODE=NULL OR @PROCODE=''

  RETURN -1;

  ELSE

   BEGIN

   UPDATE PRODUCTS SET PRODUCTCODE=@PROCODE, PRODUCTNAME=@PRONAME, PRODUCTLINE=@PROLINE WHERE PRODUCTID=@PROID;

   RETURN 1;

  END

 end try

 begin catch

 return -1;

 end catch;

END

GO

/****** Object:  StoredProcedure [dbo].[PRODUCT_DEL]    Script Date: 11/04/2011 13:37:44 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[PRODUCT_DEL]

 -- Add the parameters for the stored procedure here

 @PROID CHAR(36)

AS

BEGIN

 -- SET NOCOUNT ON added to prevent extra result sets from

 -- interfering with SELECT statements.

 SET NOCOUNT ON;

 begin try

   BEGIN

   DELETE PRODUCTS WHERE PRODUCTID=@PROID;

   RETURN 1;

  END

 end try

 begin catch

 return -1;

 end catch;

END

GO

/****** Object:  StoredProcedure [dbo].[PRODUCT_ADD]    Script Date: 11/04/2011 13:37:44 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[PRODUCT_ADD]

 -- Add the parameters for the stored procedure here

 @PROID CHAR(36) OUTPUT,

 @PROCODE NVARCHAR(50),

 @PRONAME NVARCHAR(50),

 @PROLINE NVARCHAR(50)

AS

BEGIN

 -- SET NOCOUNT ON added to prevent extra result sets from

 -- interfering with SELECT statements.

 SET NOCOUNT ON;

 begin try

 IF @PROCODE=NULL OR @PROCODE=''

  RETURN -1;

  ELSE

   BEGIN

   SET @PROID = NEWID();

   INSERT INTO PRODUCTS( PRODUCTID, PRODUCTCODE, PRODUCTNAME, PRODUCTLINE) VALUES (@PROID,@PROCODE,@PRONAME,@PROLINE);

   RETURN 1;

  END

 end try

 begin catch

 return -1;

 end catch;

END

GO

Bạn đang đọc truyện trên: Truyen247.Pro

Trước Sau
Tags: