本文共 4829 字,大约阅读时间需要 16 分钟。
use mastergoif DB_ID(N'care365') is not null--如果数据库存在,则删除它drop database care365gocreate database care365on primary(name=care1,filename='C:/database/care365.mdf',--主文件组放在C盘下size=10MB,filegrowth=15%),filegroup caregroup1(name=care2,filename='D:/database/care365_group1.ndf',--在D盘上创建一个文件组size=10MB,filegrowth=15%),filegroup caregroup2--该文件组分布在D和E两个盘符下(name=care3,filename='D:/database/care365_group2.ndf',size=10MB,filegrowth=15%),(name=care4,filename='E:/database/care365_group2.ndf',size=10MB,filegrowth=15%)log on(name=care_log,filename='c:/database/care365.ldf',--将日志文件放到C盘下size=10MB,filegrowth=15%)gouse care365goif OBJECT_ID(N'Customer') is not nulldrop table dbo.customergocreate table dbo.Customer(ID UNIQUEIDENTIFIER ROWGUIDCOL PRIMARY KEY NOT NULL CONSTRAINT DF_Customer_id DEFAULT (NEWSEQUENTIALID()),Name nvarchar(50) not null,number nvarchar(50) not null constraint DF_Student_Number default (N'无'))on caregroup1;goinsert dbo.Customer (Name,number) values (N'张三',N'001');insert dbo.Customer (Name,number) values (N'李四',N'002');insert dbo.Customer (Name,number) values (N'王五',N'003');insert dbo.Customer (Name,number) values (N'赵六',N'004');goselect * from dbo.Customerif OBJECT_ID(N'Product') is not nulldrop table dbo.Productgocreate table dbo.Product(ID UNIQUEIDENTIFIER ROWGUIDCOL PRIMARY KEY NOT NULL CONSTRAINT DF_Product_id DEFAULT (NEWSEQUENTIALID()),Name nvarchar(512) not null,Code nvarchar(50) not null constraint DF_Product_Code default (N'无'),Price money not null constraint DF_product_price default ((0)))on caregroup1goinsert dbo.Product (Name,Code,Price) values (N'奥迪 A4L 2010款 3.2FSI quattro 旗舰型',N'Audi_A4L_3.2FSI_quattro',57.81*10000);insert dbo.Product (Name,Code,Price) values (N'奥迪 A6L 2010款 3.0TFSI quattro 豪华型',N'Audi_A6L_3.0TFSI_quattro',69.60*10000);insert dbo.Product (Name,Code,Price) values (N'奥迪 A8L 2009款 6.0L quattro 专享尊崇型',N'Audi_A8L_6.0_quattro',291*10000);insert dbo.Product (Name,Code,Price) values (N'奥迪 Q5 2010款 2.0TFSI 豪华型',N'Audi_Q5_2.0TFSI',60.39*10000);insert dbo.Product (Name,Code,Price) values (N'奥迪 Q7 2010款 4.2FSI quattro 豪华型',N'Audi_Q7_4.2FSI_quattro',145*10000);goselect * from dbo.Productif OBJECT_ID(N'Orders') is not nulldrop table dbo.Ordersgocreate table dbo.Orders(ID UNIQUEIDENTIFIER ROWGUIDCOL PRIMARY KEY NOT NULL CONSTRAINT DF_Orders_id DEFAULT (NEWSEQUENTIALID()),CreateTime datetime not null constraint DF_Orders_CreateTime default(getdate()),CustomerID UNIQUEIDENTIFIER not null)on caregroup2goinsert dbo.Orders (CustomerID) values ('00AC9FF3-348C-DF11-A98B-001E37DA94AB');insert dbo.Orders (CustomerID) values ('01AC9FF3-348C-DF11-A98B-001E37DA94AB');insert dbo.Orders (CustomerID) values ('02AC9FF3-348C-DF11-A98B-001E37DA94AB');insert dbo.Orders (CustomerID) values ('03AC9FF3-348C-DF11-A98B-001E37DA94AB');goselect * from dbo.Ordersif OBJECT_ID(N'OrderInfo') is not nulldrop table dbo.OrderInfogocreate table dbo.OrderInfo(ID UNIQUEIDENTIFIER ROWGUIDCOL PRIMARY KEY NOT NULL CONSTRAINT DF_OrderInfo_id DEFAULT (NEWSEQUENTIALID()),OrdersID UNIQUEIDENTIFIER not null,ProductID UNIQUEIDENTIFIER not null,Price money not null constraint DF_OrderInfo_Price default ((0)),Quantity int not null constraint DF_OrderInfo_Quantity default((0)))on caregroup2goinsert dbo.OrderInfo (OrdersID,ProductID,Price,Quantity) values ('0A2E2E09-AA8C-DF11-9EB4-001E37DA94AB','0AF16B9C-A28C-DF11-9EB4-001E37DA94AB',578100.00,1);insert dbo.OrderInfo (OrdersID,ProductID,Price,Quantity) values ('0B2E2E09-AA8C-DF11-9EB4-001E37DA94AB','0AF16B9C-A28C-DF11-9EB4-001E37DA94AB',578100.00,1);insert dbo.OrderInfo (OrdersID,ProductID,Price,Quantity) values ('0B2E2E09-AA8C-DF11-9EB4-001E37DA94AB','0BF16B9C-A28C-DF11-9EB4-001E37DA94AB',696000.00,1);insert dbo.OrderInfo (OrdersID,ProductID,Price,Quantity) values ('0C2E2E09-AA8C-DF11-9EB4-001E37DA94AB','0AF16B9C-A28C-DF11-9EB4-001E37DA94AB',578100.00,1);insert dbo.OrderInfo (OrdersID,ProductID,Price,Quantity) values ('0C2E2E09-AA8C-DF11-9EB4-001E37DA94AB','0BF16B9C-A28C-DF11-9EB4-001E37DA94AB',696000.00,1);insert dbo.OrderInfo (OrdersID,ProductID,Price,Quantity) values ('0C2E2E09-AA8C-DF11-9EB4-001E37DA94AB','0CF16B9C-A28C-DF11-9EB4-001E37DA94AB',2910000.00,1);insert dbo.OrderInfo (OrdersID,ProductID,Price,Quantity) values ('0D2E2E09-AA8C-DF11-9EB4-001E37DA94AB','0AF16B9C-A28C-DF11-9EB4-001E37DA94AB',578100.00,1);insert dbo.OrderInfo (OrdersID,ProductID,Price,Quantity) values ('0D2E2E09-AA8C-DF11-9EB4-001E37DA94AB','0CF16B9C-A28C-DF11-9EB4-001E37DA94AB',2910000.00,1);insert dbo.OrderInfo (OrdersID,ProductID,Price,Quantity) values ('0D2E2E09-AA8C-DF11-9EB4-001E37DA94AB','0DF16B9C-A28C-DF11-9EB4-001E37DA94AB',603900.00,1);insert dbo.OrderInfo (OrdersID,ProductID,Price,Quantity) values ('0D2E2E09-AA8C-DF11-9EB4-001E37DA94AB','0EF16B9C-A28C-DF11-9EB4-001E37DA94AB',1450000.00,1);goselect * from dbo.OrderInfo;
转载地址:http://ccsbb.baihongyu.com/