ylbtech-DatabaseDesgin:Microsoft-PetSop4.0(宠物商店)-数据库设计-Sql

DatabaseName:PetShop(宠物商店)

Model:宠物商店网站

Type:专业网站

Url:

1.A，数据库关系图(Database Diagram) 返回顶部

 

1.B，数据库设计脚本(Database Design Script) – 批处理创建数据返回顶部

1.B.1，Creating Database…

1.B.1.1,Sql/CreateDatabase1.sql

USE [master];

CREATE DATABASE [MSPetShop4];

1.B.1.2,Sql/CreateDatabase2.sql

USE [master]

CREATE DATABASE [MSPetShop4Orders]

1.B.1.3,Sql/CreateDatabase3.sql

USE [master]

CREATE DATABASE [MSPetShop4Profile]

 

1.B.2，Configuring Logins…

1.B.2.1,Sql/CreateDBLogin1.sql

USE [MSPetShop4]

if not exists (select * from master.dbo.syslogins where loginname = N\'mspetshop\')
BEGIN
    exec sp_addlogin \'mspetshop\' ,\'pass@word1\', \'MSPetShop4\'
END

exec sp_grantdbaccess \'mspetshop\'

exec sp_addrolemember \'db_owner\', \'mspetshop\'

View Code

1.B.2.2,Sql/CreateDBLogin2.sql

USE [MSPetShop4Orders]

if not exists (select * from master.dbo.syslogins where loginname = N\'mspetshop\')
BEGIN
    exec sp_addlogin \'mspetshop\' ,\'pass@word1\', \'MSPetShop4Orders\'
END

exec sp_grantdbaccess \'mspetshop\'

exec sp_addrolemember \'db_owner\', \'mspetshop\'

View Code

1.B.2.3,Sql/CreateDBLogin3.sql

USE [MSPetShop4Profile]

if not exists (select * from master.dbo.syslogins where loginname = N\'mspetshop\')
BEGIN
    exec sp_addlogin \'mspetshop\' ,\'pass@word1\', \'MSPetShop4Profile\'
END

exec sp_grantdbaccess \'mspetshop\'

exec sp_addrolemember \'db_owner\', \'mspetshop\'

View Code

1.B.2.4,Sql/CreateDBLogin4.sql

USE [MSPetShop4Services]

if not exists (select * from master.dbo.syslogins where loginname = N\'mspetshop\')
BEGIN
    exec sp_addlogin \'mspetshop\' ,\'pass@word1\', \'MSPetShop4Services\'
END

exec sp_grantdbaccess \'mspetshop\'

exec sp_addrolemember \'db_owner\', \'mspetshop\'

View Code

1.B.3，Creating Tables…

1.B.3.1, Sql/CreateTables1.sql

USE [MSPetShop4]

CREATE TABLE [Category] (
    [CategoryId] varchar(10) PRIMARY KEY,
    [Name] varchar(80) NULL,
    [Descn] varchar(255) NULL
)

CREATE TABLE [Inventory] (
    [ItemId] varchar(10) PRIMARY KEY,
    [Qty] int NOT NULL
)

CREATE TABLE [Supplier] (
    [SuppId] int PRIMARY KEY,
    [Name] varchar(80) NULL,
    [Status] varchar(2) NOT NULL,
    [Addr1] varchar(80) NULL,
    [Addr2] varchar(80) NULL,
    [City] varchar(80) NULL,
    [State] varchar(80) NULL,
    [Zip] varchar(5) NULL,
    [Phone] varchar(40) NULL 
)

CREATE TABLE [Product] (
    [ProductId] varchar(10) PRIMARY KEY,
    [CategoryId] varchar(10) NOT NULL REFERENCES [Category]([CategoryId]),
    [Name] varchar(80) NULL,
    [Descn] varchar(255) NULL,
    [Image] varchar(80) NULL
)

CREATE TABLE [Item] (
    [ItemId] varchar(10) PRIMARY KEY,
    [ProductId] varchar(10) NOT NULL REFERENCES [Product]([ProductId]),
    [ListPrice] decimal(10, 2) NULL,
    [UnitCost] decimal(10, 2) NULL,
    [Supplier] int NULL REFERENCES [Supplier]([SuppId]),
    [Status] varchar(2) NULL,
    [Name] varchar(80) NULL,
    [Image] varchar(80) NULL
)

CREATE INDEX [IxItem] ON [Item]([ProductId], [ItemId], [ListPrice], [Name])

CREATE INDEX [IxProduct1] ON [Product]([Name])
CREATE INDEX [IxProduct2] ON [Product]([CategoryId])
CREATE INDEX [IxProduct3] ON [Product]([CategoryId], [Name])
CREATE INDEX [IxProduct4] ON [Product]([CategoryId], [ProductId], [Name])

View Code

1.B.3.2, Sql/CreateTables2.sql

USE [MSPetShop4Orders]

CREATE TABLE [Orders] (
    [OrderId] int IDENTITY PRIMARY KEY,
    [UserId] varchar(20) NOT NULL,
    [OrderDate] datetime NOT NULL,
    [ShipAddr1] varchar(80) NOT NULL,
    [ShipAddr2] varchar(80) NULL,
    [ShipCity] varchar(80) NOT NULL,
    [ShipState] varchar(80) NOT NULL,
    [ShipZip] varchar(20) NOT NULL,
    [ShipCountry] varchar(20) NOT NULL,
    [BillAddr1] varchar(80) NOT NULL,
    [BillAddr2] varchar(80) NULL,
    [BillCity] varchar(80) NOT NULL,
    [BillState] varchar(80) NOT NULL,
    [BillZip] varchar(20) NOT NULL,
    [BillCountry] varchar(20) NOT NULL,
    [Courier] varchar(80) NOT NULL,
    [TotalPrice] decimal(10, 2) NOT NULL,
    [BillToFirstName] varchar(80) NOT NULL,
    [BillToLastName] varchar(80) NOT NULL,
    [ShipToFirstName] varchar(80) NOT NULL,
    [ShipToLastName] varchar(80) NOT NULL,
    [AuthorizationNumber] int NOT NULL,
    [Locale] varchar(20) NOT NULL
)

CREATE TABLE [LineItem] (
    [OrderId] int NOT NULL REFERENCES [Orders]([OrderId]),
    [LineNum] int NOT NULL,
    [ItemId] varchar(10) NOT NULL,
    [Quantity] int NOT NULL,
    [UnitPrice] decimal(10, 2) NOT NULL,
    CONSTRAINT [PkLineItem] PRIMARY KEY ([OrderId], [LineNum])
)

CREATE TABLE [OrderStatus] (
    [OrderId] int NOT NULL REFERENCES [Orders]([OrderId]),
    [LineNum] int NOT NULL,
    [Timestamp] datetime NOT NULL,
    [Status] varchar(2) NOT NULL,
    CONSTRAINT [PkOrderStatus] PRIMARY KEY ([OrderId], [LineNum])
)

View Code

1.B.3.3, Sql/CreateTables3.sql

USE [MSPetShop4Profile]

CREATE TABLE [Profiles] (
    [UniqueID] [int] IDENTITY (1, 1) NOT NULL ,
    [Username] [varchar] (256)  NOT NULL ,
    [ApplicationName] [varchar] (256)  NOT NULL ,
    [IsAnonymous] [bit] NULL ,
    [LastActivityDate] [datetime] NULL ,
    [LastUpdatedDate] [datetime] NULL ,
    CONSTRAINT [PK_Profiles_1] PRIMARY KEY  NONCLUSTERED 
    (
        [UniqueID]
    )  ON [PRIMARY] ,
    CONSTRAINT [PK_Profiles] UNIQUE  CLUSTERED 
    (
        [Username],
        [ApplicationName]
    )  ON [PRIMARY] 
) ON [PRIMARY]

CREATE TABLE [Cart] (
    [UniqueID] [int] NOT NULL ,
    [ItemId] [varchar] (10)  NOT NULL ,
    [Name] [varchar] (80)  NOT NULL ,
    [Type] [varchar] (80)  NOT NULL ,
    [Price] [decimal](10, 2) NOT NULL ,
    [CategoryId] [varchar] (10)  NOT NULL ,
    [ProductId] [varchar] (10)  NOT NULL ,
    [IsShoppingCart] [bit]  NOT NULL ,
    [Quantity] [int] NOT NULL ,
    CONSTRAINT [FK_Cart_Profiles] FOREIGN KEY 
    (
        [UniqueID]
    ) REFERENCES [Profiles] (
        [UniqueID]
    ) ON DELETE CASCADE  ON UPDATE CASCADE 
) ON [PRIMARY]

CREATE TABLE [Account] (
    [UniqueID] [int] NOT NULL ,
    [Email] [varchar] (80)  NOT NULL ,
    [FirstName] [varchar] (80)  NOT NULL ,
    [LastName] [varchar] (80)  NOT NULL ,
    [Address1] [varchar] (80)  NOT NULL ,
    [Address2] [varchar] (80)  NULL ,
    [City] [varchar] (80)  NOT NULL ,
    [State] [varchar] (80)  NOT NULL ,
    [Zip] [varchar] (20)  NOT NULL ,
    [Country] [varchar] (20)  NOT NULL ,
    [Phone] [varchar] (20)  NULL ,
    CONSTRAINT [FK_Account_Profiles] FOREIGN KEY (
        [UniqueID]
    ) REFERENCES [Profiles] (
        [UniqueID]
    ) ON DELETE CASCADE  ON UPDATE CASCADE 
) ON [PRIMARY]

CREATE  CLUSTERED  INDEX [FK_Cart_UniqueID] ON [dbo].[Cart]([UniqueID]) ON [PRIMARY]

CREATE  CLUSTERED  INDEX [FK_Account_UniqueID] ON [dbo].[Account]([UniqueID]) ON [PRIMARY]

CREATE NONCLUSTERED INDEX [IX_SHOPPINGCART] ON [dbo].[Cart] (
    [IsShoppingCart] ASC
)

View Code

1.B.4，Loading Data…

1.B.4.1,Sql/LoadTables1.sql

USE [MSPetShop4]

INSERT INTO [Category] VALUES (\'FISH\', \'Fish\', \'Fish\')
INSERT INTO [Category] VALUES (\'BYARD\', \'Backyard\',\'Backyard\')
INSERT INTO [Category] VALUES (\'BIRDS\', \'Birds\', \'Birds\')
INSERT INTO [Category] VALUES (\'BUGS\', \'Bugs\', \'Bugs\')
INSERT INTO [Category] VALUES (\'EDANGER\', \'Endangered\', \'Endangered\')

INSERT INTO [Supplier] VALUES (1, \'XYZ Pets\', \'AC\', \'600 Avon Way\', \'\', \'Los Angeles\', \'CA\', \'94024\', \'212-947-0797\')
INSERT INTO [Supplier] VALUES (2, \'ABC Pets\', \'AC\', \'700 Abalone Way\', \'\', \'San Francisco\', \'CA\', \'94024\', \'415-947-0797\')

INSERT INTO [Product] VALUES (\'FI-01\', \'FISH\', \'Meno\', \'Your worried tiny friend warns you about life\'\'s dangers\', \'~/Prod_Images/Fish/icon-meno.gif\')
INSERT INTO [Product] VALUES (\'FI-02\', \'FISH\', \'Balloonfish\', \'It\'\'s your thermometer - the hotter it gets the bigger it gets\', \'~/Prod_Images/Fish/icon-ballonfish.gif\')
INSERT INTO [Product] VALUES (\'FI-03\', \'FISH\', \'Blindfish\', \'Likes pressure - ideal for divorcing couples\', \'~/Prod_Images/Fish/icon-blindfish.gif\')
INSERT INTO [Product] VALUES (\'FI-04\', \'FISH\', \'Crabfish\', \'Dances and sings every time you feed it!\', \'~/Prod_Images/Fish/icon-Crabfish.gif\')
INSERT INTO [Product] VALUES (\'FI-05\', \'FISH\', \'Eucalyptus\', \'For the tickle on your hands: you\'\'ll love the massage\', \'~/Prod_Images/Fish/icon-eucalyptus.gif\')
INSERT INTO [Product] VALUES (\'FI-06\', \'FISH\', \'Mister No\', \'Need a companion for the dark times?\', \'~/Prod_Images/Fish/icon-misterno.gif\')
INSERT INTO [Product] VALUES (\'FI-07\', \'FISH\', \'Nosyfish\', \'Don\'\'t underestimate this one - it bites!\', \'~/Prod_Images/Fish/icon-nosyfish.gif\')
INSERT INTO [Product] VALUES (\'FI-08\', \'FISH\', \'Tooth Ferry\', \'Very sensitive vegetarian, needs food every two months\', \'~/Prod_Images/Fish/icon-toothferry.gif\')
INSERT INTO [Product] VALUES (\'BY-01\', \'BYARD\', \'Sheep\', \'Your soft hugging buddy\', \'~/Prod_Images/Backyard/icon-sheep.gif\')
INSERT INTO [Product] VALUES (\'BY-02\', \'BYARD\', \'Cat\', \'The friend you will never see\', \'~/Prod_Images/Backyard/icon-cat.gif\')
INSERT INTO [Product] VALUES (\'BY-03\', \'BYARD\', \'Raccoon\', \'Always keeps your dishes clean\', \'~/Prod_Images/Backyard/icon-raccoon.gif\')
INSERT INTO [Product] VALUES (\'BY-04\', \'BYARD\', \'Goose\', \'For your protection delivered in our special safety-bag\', \'~/Prod_Images/Backyard/icon-goose.gif\')
INSERT INTO [Product] VALUES (\'BY-05\', \'BYARD\', \'Crab\', \'The common house crab which lives in the refrigerator\', \'~/Prod_Images/Backyard/icon-crab.gif\')
INSERT INTO [Product] VALUES (\'BY-06\', \'BYARD\', \'Skunk\', \'You will love it - especially when you have your in-laws visiting\', \'~/Prod_Images/Backyard/icon-skunk.gif\')
INSERT INTO [Product] VALUES (\'BY-07\', \'BYARD\', \'Zebra\', \'The horse of the modern girl\', \'~/Prod_Images/Backyard/icon-zebra.gif\')
INSERT INTO [Product] VALUES (\'BD-01\', \'BIRDS\', \'Pelican\', \'Will sit in your garden and admire nature\', \'~/Prod_Images/Birds/icon-pelican.gif\')
INSERT INTO [Product] VALUES (\'BD-02\', \'BIRDS\', \'Penguin\', \'Guaranteed to stay by your side\', \'~/Prod_Images/Birds/icon-penguin.gif\')
INSERT INTO [Product] VALUES (\'BD-03\', \'BIRDS\', \'Pteranodon\', \'Can\'\'t let go of the past? This is your bird\', \'~/Prod_Images/Birds/icon-pteranodon.gif\')
INSERT INTO [Product] VALUES (\'BD-04\', \'BIRDS\', \'Owl\', \'Your personal dictionary ?night & day\', \'~/Prod_Images/Birds/icon-owl.gif\')
INSERT INTO [Product] VALUES (\'BD-05\', \'BIRDS\', \'Duck\', \'Lisps but otherwise sings well\', \'~/Prod_Images/Birds/icon-duck.gif\')
INSERT INTO [Product] VALUES (\'BG-01\', \'BUGS\', \'Ant\', \'Trash your vacuum cleaner\', \'~/Prod_Images/Bugs/icon-ant.gif\')
INSERT INTO [Product] VALUES (\'BG-02\', \'BUGS\', \'Butterfly\', \'Increased beauty with age\', \'~/Prod_Images/Bugs/icon-butterfly.gif\')
INSERT INTO [Product] VALUES (\'BG-03\', \'BUGS\', \'Spider\', \'Loves a good massage\', \'~/Prod_Images/Bugs/icon-spider.gif\')
INSERT INTO [Product] VALUES (\'BG-04\', \'BUGS\', \'Slug\', \'Your soft hugging buddy\', \'~/Prod_Images/Bugs/icon-slug.gif\')
INSERT INTO [Product] VALUES (\'BG-05\', \'BUGS\', \'Frog\', \'Want to get rid of an insect previously bought?\', \'~/Prod_Images/Bugs/icon-frog.gif\')
INSERT INTO [Product] VALUES (\'BG-06\', \'BUGS\', \'Dragonfly\', \'Beware of the meat lover\', \'~/Prod_Images/Bugs/icon-dragonfly.gif\')
INSERT INTO [Product] VALUES (\'DR-01\', \'EDANGER\', \'Skeleton\', \'Dumb but hollow\', \'~/Prod_Images/Endangered/icon-skeleton.gif\')
INSERT INTO [Product] VALUES (\'DR-02\', \'EDANGER\', \'Pet\', \'The originals ?honestly!\', \'~/Prod_Images/Endangered/icon-pet.gif\')
INSERT INTO [Product] VALUES (\'DR-03\', \'EDANGER\', \'Dino\', \'Special offer: only for a limited time\', \'~/Prod_Images/Endangered/icon-dino.gif\')
INSERT INTO [Product] VALUES (\'DR-04\', \'EDANGER\', \'Panda\', \'Last one ?go for it!\', \'~/Prod_Images/Endangered/icon-panda.gif\')
INSERT INTO [Product] VALUES (\'DR-05\', \'EDANGER\', \'Fish\', \'They are waiting for your help\', \'~/Prod_Images/Endangered/icon-fish.gif\')

INSERT INTO [Item] VALUES (\'EST-1\', \'FI-01\', 16.50, 10.00, 1, \'P\', \'Happy\', \'~/Prod_Images/Fish/item-meno-happy.gif\')
INSERT INTO [Item] VALUES (\'EST-2\', \'FI-01\', 17.50, 10.00, 1, \'P\', \'Camouflage\', \'~/Prod_Images/Fish/item-meno-camouflage.gif\')
INSERT INTO [Item] VALUES (\'EST-3\', \'FI-01\', 15.90, 10.00, 1, \'P\', \'Worried\', \'~/Prod_Images/Fish/item-meno-worried.gif\')
INSERT INTO [Item] VALUES (\'EST-4\', \'FI-02\', 17.50, 12.00, 1, \'P\', \'Extra Stretch\', \'~/Prod_Images/Fish/item-balloon-extra-stretch.gif\')
INSERT INTO [Item] VALUES (\'EST-5\', \'FI-02\', 18.90, 12.00, 1, \'P\', \'Natural\', \'~/Prod_Images/Fish/item-balloon-natural.gif\')
INSERT INTO [Item] VALUES (\'EST-6\', \'FI-02\', 19.50, 12.00, 1, \'P\', \'Flammable\', \'~/Prod_Images/Fish/item-balloon-flammable.gif\')
INSERT INTO [Item] VALUES (\'EST-7\', \'FI-03\', 21.50, 15.00, 1, \'P\', \'Blind\', \'~/Prod_Images/Fish/item-blindfish-blind.gif\')
INSERT INTO [Item] VALUES (\'EST-8\', \'FI-03\', 22.50, 15.00, 1, \'P\', \'Short Sighted\', \'~/Prod_Images/Fish/item-blindfish-shortsighted.gif\')
INSERT INTO [Item] VALUES (\'EST-9\', \'FI-03\', 24.50, 15.00, 1, \'P\', \'Far Sighted\', \'~/Prod_Images/Fish/item-blindfish-farsighted.gif\')
INSERT INTO [Item] VALUES (\'EST-10\', \'FI-04\', 18.50, 12.00, 1, \'P\', \'Tap Dance\', \'~/Prod_Images/Fish/item-Crabfish-tabdance.gif\')
INSERT INTO [Item] VALUES (\'EST-11\', \'FI-04\', 19.50, 12.00, 1, \'P\', \'Ballet\', \'~/Prod_Images/Fish/item-Crabfish-ballet.gif\')
INSERT INTO [Item] VALUES (\'EST-12\', \'FI-04\', 18.90, 12.00, 1, \'P\', \'Ballroom\', \'~/Prod_Images/Fish/item-Crabfish-ballroom.gif\')
INSERT INTO [Item] VALUES (\'EST-13\', \'FI-05\', 16.50, 10.00, 1, \'P\', \'Long Arms\', \'~/Prod_Images/Fish/item-eucalyptus-longarms.gif\')
INSERT INTO [Item] VALUES (\'EST-14\', \'FI-05\', 16.90, 10.00, 1, \'P\', \'Short Arms\', \'~/Prod_Images/Fish/item-eucalyptus-shortarms.gif\')
INSERT INTO [Item] VALUES (\'EST-15\', \'FI-06\', 13.90, 8.00, 1, \'P\', \'Black\', \'~/Prod_Images/Fish/item-misterno-black.gif\')
INSERT INTO [Item] VALUES (\'EST-16\', \'FI-06\', 14.50, 8.00, 1, \'P\', \'Sepia\', \'~/Prod_Images/Fish/item-misterno-sepia.gif\')
INSERT INTO [Item] VALUES (\'EST-17\', \'FI-06\', 15.50, 8.00, 1, \'P\', \'Sable\', \'~/Prod_Images/Fish/item-misterno-sable.gif\')
INSERT INTO [Item] VALUES (\'EST-18\', \'FI-07\', 16.50, 10.00, 1, \'P\', \'Invidious\', \'~/Prod_Images/Fish/item-nosyfish-invidious.gif\')
INSERT INTO [Item] VALUES (\'EST-19\', \'FI-07\', 17.50, 10.00, 1, \'P\', \'Beastly\', \'~/Prod_Images/Fish/item-nosyfish-beastly.gif\')
INSERT INTO [Item] VALUES (\'EST-20\', \'FI-07\', 18.50, 10.00, 1, \'P\', \'Mean\', \'~/Prod_Images/Fish/item-nosyfish-mean.gif\')
INSERT INTO [Item] VALUES (\'EST-21\', \'FI-07\', 19.50, 10.00, 1, \'P\', \'Sneaky\', \'~/Prod_Images/Fish/item-nosyfish-sneaky.gif\')
INSERT INTO [Item] VALUES (\'EST-22\', \'FI-08\', 28.50, 20.00, 1, \'P\', \'Toothless\', \'~/Prod_Images/Fish/item-toothferry-toothless.gif\')
INSERT INTO [Item] VALUES (\'EST-23\', \'FI-08\', 29.50, 20.00, 1, \'P\', \'With Teeth\', \'~/Prod_Images/Fish/item-toothferry-withteeth.gif\')
INSERT INTO [Item] VALUES (\'EST-24\', \'BY-01\', 120.95, 99.00, 1, \'P\', \'Fuzzy\', \'~/Prod_Images/Backyard/item-sheep-fuzzy.gif\')
INSERT INTO [Item] VALUES (\'EST-25\', \'BY-01\', 130.95, 99.00, 1, \'P\', \'Ironed\', \'~/Prod_Images/Backyard/item-sheep-ironed.gif\')
INSERT INTO [Item] VALUES (\'EST-26\', \'BY-02\', 14.95, 2.00, 1, \'P\', \'Transparent\', \'~/Prod_Images/Backyard/item-cat-transparent.gif\')
INSERT INTO [Item] VALUES (\'EST-27\', \'BY-02\', 15.95, 2.00, 1, \'P\', \'Patterned\', \'~/Prod_Images/Backyard/item-cat-patterned.gif\')
INSERT INTO [Item] VALUES (\'EST-28\', \'BY-02\', 18.95, 2.00, 1, \'P\', \'Uncolored\', \'~/Prod_Images/Backyard/item-cat-uncolored.gif\')
INSERT INTO [Item] VALUES (\'EST-29\', \'BY-03\', 42.95, 30.00, 1, \'P\', \'Long Tongue\', \'~/Prod_Images/Backyard/item-raccoon-long-tongue.gif\')
INSERT INTO [Item] VALUES (\'EST-30\', \'BY-03\', 45.95, 30.00, 1, \'P\', \'Rough Tongue\', \'~/Prod_Images/Backyard/item-raccoon-rough-tongue.gif\')
INSERT INTO [Item] VALUES (\'EST-31\', \'BY-03\', 48.95, 30.00, 1, \'P\', \'Hairy Tongue\', \'~/Prod_Images/Backyard/item-raccoon-hairy-tongue.gif\')
INSERT INTO [Item] VALUES (\'EST-32\', \'BY-04\', 20.95, 12.00, 1, \'P\', \'Feathered\', \'~/Prod_Images/Backyard/item-goose-feathered.gif\')
INSERT INTO [Item] VALUES (\'EST-33\', \'BY-04\', 22.95, 12.00, 1, \'P\', \'Plucked\', \'~/Prod_Images/Backyard/item-goose-plucked.gif\')
INSERT INTO [Item] VALUES (\'EST-34\', \'BY-05\', 12.95, 10.00, 1, \'P\', \'Red\', \'~/Prod_Images/Backyard/item-crab-red.gif\')
INSERT INTO [Item] VALUES (\'EST-35\', \'BY-05\', 13.95, 10.00, 1, \'P\', \'Orange\', \'~/Prod_Images/Backyard/item-crab-orange.gif\')
INSERT INTO [Item] VALUES (\'EST-36\', \'BY-05\', 14.95, 10.00, 1, \'P\', \'Dotted\', \'~/Prod_Images/Backyard/item-crab-dotted.gif\')
INSERT INTO [Item] VALUES (\'EST-37\', \'BY-06\', 18.95, 12.00, 1, \'P\', \'Bad Smell\', \'~/Prod_Images/Backyard/item-skunk-bad-smell.gif\')
INSERT INTO [Item] VALUES (\'EST-38\', \'BY-06\', 20.95, 12.00, 1, \'P\', \'Really Bad Smell\', \'~/Prod_Images/Backyard/item-skunk-really-bad-smell.gif\')
INSERT INTO [Item] VALUES (\'EST-39\', \'BY-06\', 22.95, 12.00, 1, \'P\', \'Worst Smell\', \'~/Prod_Images/Backyard/item-skunk-worst-smell.gif\')
INSERT INTO [Item] VALUES (\'EST-40\', \'BY-07\', 859.95, 500.00, 1, \'P\', \'Tiny\', \'~/Prod_Images/Backyard/item-zebra-tiny.gif\')
INSERT INTO [Item] VALUES (\'EST-41\', \'BY-07\', 879.95, 500.00, 1, \'P\', \'Small\', \'~/Prod_Images/Backyard/item-zebra-small.gif\')
INSERT INTO [Item] VALUES (\'EST-42\', \'BY-07\', 899.95, 500.00, 1, \'P\', \'Medium\', \'~/Prod_Images/Backyard/item-zebra-medium.gif\')
INSERT INTO [Item] VALUES (\'EST-43\', \'BY-07\', 949.95, 500.00, 1, \'P\', \'Large\', \'~/Prod_Images/Backyard/item-zebra-large.gif\')
INSERT INTO [Item] VALUES (\'EST-44\', \'BD-01\', 41.95, 30.00, 1, \'P\', \'Flower Loving\', \'~/Prod_Images/Birds/item-pelican-flowerloving.gif\')
INSERT INTO [Item] VALUES (\'EST-45\', \'BD-01\', 45.95, 30.00, 1, \'P\', \'Grass Loving\', \'~/Prod_Images/Birds/item-pelican-grassloving.gif\')
INSERT INTO [Item] VALUES (\'EST-46\', \'BD-02\', 120.99, 99.00, 1, \'P\', \'Adventurous\', \'~/Prod_Images/Birds/item-penguine-adventurous.gif\')
INSERT INTO [Item] VALUES (\'EST-47\', \'BD-02\', 130.99, 99.00, 1, \'P\', \'Homey\', \'~/Prod_Images/Birds/item-penguine-homey.gif\')
INSERT INTO [Item] VALUES (\'EST-48\', \'BD-03\', 130.99, 99.00, 1, \'P\', \'Old\', \'~/Prod_Images/Birds/item-pteranodon-old.gif\')
INSERT INTO [Item] VALUES (\'EST-49\', \'BD-03\', 130.99, 99.00, 1, \'P\', \'Ancient\', \'~/Prod_Images/Birds/item-pteranodon-ancient.gif\')
INSERT INTO [Item] VALUES (\'EST-50\', \'BD-04\', 80.99, 50.00, 1, \'P\', \'Day\', \'~/Prod_Images/Birds/item-owl-day.gif\')
INSERT INTO [Item] VALUES (\'EST-51\', \'BD-04\', 85.99, 50.00, 1, \'P\', \'Night\', \'~/Prod_Images/Birds/item-owl-night.gif\')
INSERT INTO [Item] VALUES (\'EST-52\', \'BD-05\', 33.99, 20.00, 1, \'P\', \'Domestic\', \'~/Prod_Images/Birds/item-duck-domestic.gif\')
INSERT INTO [Item] VALUES (\'EST-53\', \'BD-05\', 38.99, 20.00, 1, \'P\', \'Wild\', \'~/Prod_Images/Birds/item-duck-wild.gif\')
INSERT INTO [Item] VALUES (\'EST-54\', \'BG-01\', 0.25, 0.02, 1, \'P\', \'Worker\', \'~/Prod_Images/Bugs/item-ant-worker.gif\')
INSERT INTO [Item] VALUES (\'EST-55\', \'BG-01\', 0.30, 0.02, 1, \'P\', \'Queen\', \'~/Prod_Images/Bugs/item-ant-queen.gif\')
INSERT INTO [Item] VALUES (\'EST-56\', \'BG-01\', 0.50, 0.02, 1, \'P\', \'Soldier\', \'~/Prod_Images/Bugs/item-ant-soldier.gif\')
INSERT INTO [Item] VALUES (\'EST-57\', \'BG-02\', 0.70, 0.10, 1, \'P\', \'Larva\', \'~/Prod_Images/Bugs/item-butterfly-larva.gif\')
INSERT INTO [Item] VALUES (\'EST-58\', \'BG-02\', 0.80, 0.10, 1, \'P\', \'Pupa\', \'~/Prod_Images/Bugs/item-butterfly-pupa.gif\')
INSERT INTO [Item] VALUES (\'EST-59\', \'BG-02\', 0.90, 0.10, 1, \'P\', \'Adult\', \'~/Prod_Images/Bugs/item-butterfly-adult.gif\')
INSERT INTO [Item] VALUES (\'EST-60\', \'BG-03\', 2.50, 1.00, 1, \'P\', \'Arniladisplicata\', \'~/Prod_Images/Bugs/item-spider-aranielladisplicata.gif\')
INSERT INTO [Item] VALUES (\'EST-61\', \'BG-03\', 2.60, 1.00, 1, \'P\', \'Dysdera Crocata\', \'~/Prod_Images/Bugs/item-spider-dysderacrocata.gif\')
INSERT INTO [Item] VALUES (\'EST-62\', \'BG-04\', 0.89, 0.15, 1, \'P\', \'Naked\', \'~/Prod_Images/Bugs/item-slug-naked.gif\')
INSERT INTO [Item] VALUES (\'EST-63\', \'BG-04\', 0.99, 0.15, 1, \'P\', \'Habitat\', \'~/Prod_Images/Bugs/item-slug-habitat.gif\')
INSERT INTO [Item] VALUES (\'EST-64\', \'BG-05\', 8.99, 2.50, 1, \'P\', \'False\', \'~/Prod_Images/Bugs/item-frog-false.gif\')
INSERT INTO [Item] VALUES (\'EST-65\', \'BG-05\', 9.99, 2.50, 1, \'P\', \'True\', \'~/Prod_Images/Bugs/item-frog-true.gif\')
INSERT INTO [Item] VALUES (\'EST-66\', \'BG-06\', 1.20, 0.80, 1, \'P\', \'Omnivore\', \'~/Prod_Images/Bugs/item-dragonfly-omnivore.gif\')
INSERT INTO [Item] VALUES (\'EST-67\', \'BG-06\', 1.30, 0.80, 1, \'P\', \'Vegetarian\', \'~/Prod_Images/Bugs/item-dragonfly-vegetarian.gif\')
INSERT INTO [Item] VALUES (\'EST-68\', \'BG-06\', 1.40, 0.80, 1, \'P\', \'Vegan\', \'~/Prod_Images/Bugs/item-dragonfly-vegan.gif\')
INSERT INTO [Item] VALUES (\'EST-69\', \'DR-01\', 150.00, 100.00, 1, \'P\', \'Male\', \'~/Prod_Images/Endangered/item-skeleton-male.gif\')
INSERT INTO [Item] VALUES (\'EST-70\', \'DR-01\', 160.00, 100.00, 1, \'P\', \'Female\', \'~/Prod_Images/Endangered/item-skeleton-female.gif\')
INSERT INTO [Item] VALUES (\'EST-71\', \'DR-01\', 170.00, 100.00, 1, \'P\', \'Aphrodite\', \'~/Prod_Images/Endangered/item-skeleton-aphrodite.gif\')
INSERT INTO [Item] VALUES (\'EST-72\', \'DR-01\', 180.00, 100.00, 1, \'P\', \'Hermaphrodite\', \'~/Prod_Images/Endangered/item-skeleton-hermaphrodite.gif\')
INSERT INTO [Item] VALUES (\'EST-73\', \'DR-02\', 45.00, 22.00, 1, \'P\', \'Rover\', \'~/Prod_Images/Endangered/item-pet-rover.gif\')
INSERT INTO [Item] VALUES (\'EST-74\', \'DR-02\', 48.00, 22.00, 1, \'P\', \'Trumpet\', \'~/Prod_Images/Endangered/item-pet-thumper.gif\')
INSERT INTO [Item] VALUES (\'EST-75\', \'DR-02\', 49.00, 22.00, 1, \'P\', \'Kitty\', \'~/Prod_Images/Endangered/item-pet-kitty.gif\')
INSERT INTO [Item] VALUES (\'EST-76\', \'DR-03\', 349.00, 220.00, 1, \'P\', \'Spiky\', \'~/Prod_Images/Endangered/item-dino-spiky.gif\')
INSERT INTO [Item] VALUES (\'EST-77\', \'DR-03\', 379.00, 220.00, 1, \'P\', \'Shaved\', \'~/Prod_Images/Endangered/item-dino-shaved.gif\')
INSERT INTO [Item] VALUES (\'EST-78\', \'DR-03\', 399.00, 220.00, 1, \'P\', \'Pointy\', \'~/Prod_Images/Endangered/item-dino-pointy.gif\')
INSERT INTO [Item] VALUES (\'EST-79\', \'DR-04\', 1999.00, 1500.00, 1, \'P\', \'Exclusive\', \'~/Prod_Images/Endangered/item-panda-exclusive.gif\')
INSERT INTO [Item] VALUES (\'EST-80\', \'DR-05\', 22.95, 16.00, 1, \'P\', \'Lost\', \'~/Prod_Images/Endangered/item-fish-lost.gif\')
INSERT INTO [Item] VALUES (\'EST-81\', \'DR-05\', 22.95, 16.00, 1, \'P\', \'Drunk\', \'~/Prod_Images/Endangered/item-fish-drunk.gif\')
INSERT INTO [Item] VALUES (\'EST-82\', \'DR-05\', 22.95, 16.00, 1, \'P\', \'Caught\', \'~/Prod_Images/Endangered/item-fish-caught.gif\')

INSERT INTO [Inventory] VALUES (\'EST-1\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-2\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-3\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-4\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-5\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-6\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-7\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-8\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-9\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-10\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-11\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-12\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-13\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-14\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-15\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-16\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-17\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-18\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-19\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-20\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-21\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-22\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-23\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-24\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-25\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-26\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-27\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-28\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-29\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-30\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-31\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-32\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-33\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-34\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-35\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-36\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-37\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-38\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-39\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-40\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-41\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-42\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-43\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-44\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-45\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-46\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-47\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-48\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-49\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-50\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-51\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-52\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-53\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-54\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-55\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-56\', 10000)  
INSERT INTO [Inventory] VALUES (\'EST-57\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-58\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-59\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-60\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-61\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-62\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-63\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-64\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-65\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-66\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-67\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-68\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-69\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-70\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-71\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-72\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-73\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-74\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-75\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-76\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-77\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-78\', 10000)   
INSERT INTO [Inventory] VALUES (\'EST-79\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-80\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-81\', 10000)
INSERT INTO [Inventory] VALUES (\'EST-82\', 10000)

View Code

 

1.C，数据库设计脚本(Database Design Script) – 批处理删除数据返回顶部

1.C.1，Uninstalling Database…

1.C.1.1, Sql/CreateTables1.sql

USE [master]

DECLARE @spid smallint
DECLARE @sql varchar(4000)

DECLARE crsr CURSOR FAST_FORWARD FOR
    SELECT spid FROM sysprocesses p INNER JOIN sysdatabases d ON d.[name] = \'MSPetShop4\' AND p.dbid = d.dbid

OPEN crsr
FETCH NEXT FROM crsr INTO @spid

WHILE @@FETCH_STATUS != -1
BEGIN
    SET @sql = \'KILL \' + CAST(@spid AS varchar)
    EXEC(@sql)
    FETCH NEXT FROM crsr INTO @spid
END

CLOSE crsr
DEALLOCATE crsr

DROP DATABASE [MSPetShop4]

View Code

1.C.1.2, Sql/CreateTables2.sql

USE [master]

DECLARE @spid smallint
DECLARE @sql varchar(4000)

DECLARE crsr CURSOR FAST_FORWARD FOR
    SELECT spid FROM sysprocesses p INNER JOIN sysdatabases d ON d.[name] = \'MSPetShop4Orders\' AND p.dbid = d.dbid

OPEN crsr
FETCH NEXT FROM crsr INTO @spid

WHILE @@FETCH_STATUS != -1
BEGIN
    SET @sql = \'KILL \' + CAST(@spid AS varchar)
    EXEC(@sql)
    FETCH NEXT FROM crsr INTO @spid
END

CLOSE crsr
DEALLOCATE crsr

DROP DATABASE [MSPetShop4Orders]

View Code

1.C.1.3, Sql/CreateTables3.sql

USE [master]

DECLARE @spid smallint
DECLARE @sql varchar(4000)

DECLARE crsr CURSOR FAST_FORWARD FOR
    SELECT spid FROM sysprocesses p INNER JOIN sysdatabases d ON d.[name] = \'MSPetShop4Profile\' AND p.dbid = d.dbid

OPEN crsr
FETCH NEXT FROM crsr INTO @spid

WHILE @@FETCH_STATUS != -1
BEGIN
    SET @sql = \'KILL \' + CAST(@spid AS varchar)
    EXEC(@sql)
    FETCH NEXT FROM crsr INTO @spid
END

CLOSE crsr
DEALLOCATE crsr

DROP DATABASE [MSPetShop4Profile]

View Code

1.C.1.4, Sql/CreateTables3.sql

USE [master]

DECLARE @spid smallint
DECLARE @sql varchar(4000)

DECLARE crsr CURSOR FAST_FORWARD FOR
    SELECT spid FROM sysprocesses p INNER JOIN sysdatabases d ON d.[name] = \'MSPetShop4Services\' AND p.dbid = d.dbid

OPEN crsr
FETCH NEXT FROM crsr INTO @spid

WHILE @@FETCH_STATUS != -1
BEGIN
    SET @sql = \'KILL \' + CAST(@spid AS varchar)
    EXEC(@sql)
    FETCH NEXT FROM crsr INTO @spid
END

CLOSE crsr
DEALLOCATE crsr

DROP DATABASE [MSPetShop4Services]

View Code

D,? 这两个在批处理是怎么处理的

?D.1, Sql/CreateDemoUsers.sql

USE [MSPetShop4Profile]

DECLARE @userid int

INSERT INTO [Profiles] (
    [Username], [ApplicationName], [IsAnonymous], [LastActivityDate], [LastUpdatedDate]
)
VALUES (
     \'AdamBarr\', \'.NET Pet Shop 4.0\', 0, GETDATE(), GETDATE()
)
SET @userid = (SELECT @@IDENTITY)
INSERT INTO [Account] ([UniqueID], [Email], [FirstName], [LastName], [Address1], [Address2], [City], [State], [Zip], [Country], [Phone])
     VALUES
           (@userid, \'someone@microsoft.com\', \'Adam\', \'Barr\', \'Vertigo Software, Inc.\', \'503A Canal Blvd.\', \'Point Richmond\', \'CA\', \'94804\', \'USA\', \'(510) 307-8200\')

INSERT INTO [Profiles] (
    [Username], [ApplicationName], [IsAnonymous], [LastActivityDate], [LastUpdatedDate]
)
VALUES (
     \'KimAbercrombie\', \'.NET Pet Shop 4.0\', 0, GETDATE(), GETDATE()
)
SET @userid = (SELECT @@IDENTITY)
INSERT INTO [Account] ([UniqueID], [Email], [FirstName], [LastName], [Address1], [Address2], [City], [State], [Zip], [Country], [Phone])
     VALUES
           (@userid, \'someone1@microsoft.com\', \'Kim\', \'Abercrombie\', \'Vertigo Software, Inc.\', \'503A Canal Blvd.\', \'Point Richmond\', \'CA\', \'94804\', \'USA\', \'(510) 307-8200\')
           
INSERT INTO [Profiles] (
    [Username], [ApplicationName], [IsAnonymous], [LastActivityDate], [LastUpdatedDate]
)
VALUES (
     \'RobYoung\', \'.NET Pet Shop 4.0\', 0, GETDATE(), GETDATE()
)
SET @userid = (SELECT @@IDENTITY)
INSERT INTO [Account] ([UniqueID], [Email], [FirstName], [LastName], [Address1], [Address2], [City], [State], [Zip], [Country], [Phone])
     VALUES
           (@userid, \'someone2@microsoft.com\', \'Rob\', \'Young\', \'Vertigo Software, Inc.\', \'503A Canal Blvd.\', \'Point Richmond\', \'CA\', \'94804\', \'USA\', \'(510) 307-8200\')           

INSERT INTO [Profiles] (
    [Username], [ApplicationName], [IsAnonymous], [LastActivityDate], [LastUpdatedDate]
)
VALUES (
     \'TomYoutsey\', \'.NET Pet Shop 4.0\', 0, GETDATE(), GETDATE()
)
SET @userid = (SELECT @@IDENTITY)
INSERT INTO [Account] ([UniqueID], [Email], [FirstName], [LastName], [Address1], [Address2], [City], [State], [Zip], [Country], [Phone])
     VALUES
           (@userid, \'someone3@microsoft.com\', \'Tom\', \'Youtsey\', \'Vertigo Software, Inc.\', \'503A Canal Blvd.\', \'Point Richmond\', \'CA\', \'94804\', \'USA\', \'(510) 307-8200\')           

INSERT INTO [Profiles] (
    [Username], [ApplicationName], [IsAnonymous], [LastActivityDate], [LastUpdatedDate]
)
VALUES (
     \'GaryWYukish\', \'.NET Pet Shop 4.0\', 0, GETDATE(), GETDATE()
)
SET @userid = (SELECT @@IDENTITY)
INSERT INTO [Account] ([UniqueID], [Email], [FirstName], [LastName], [Address1], [Address2], [City], [State], [Zip], [Country], [Phone])
     VALUES
           (@userid, \'someone4@microsoft.com\', \'Gary W.\', \'Yukish\', \'Vertigo Software, Inc.\', \'503A Canal Blvd.\', \'Point Richmond\', \'CA\', \'94804\', \'USA\', \'(510) 307-8200\')           

INSERT INTO [Profiles] (
    [Username], [ApplicationName], [IsAnonymous], [LastActivityDate], [LastUpdatedDate]
)
VALUES (
     \'RobCaron\', \'.NET Pet Shop 4.0\', 0, GETDATE(), GETDATE()
)
SET @userid = (SELECT @@IDENTITY)
INSERT INTO [Account] ([UniqueID], [Email], [FirstName], [LastName], [Address1], [Address2], [City], [State], [Zip], [Country], [Phone])
     VALUES
           (@userid, \'someone5@microsoft.com\', \'Rob\', \'Caron\', \'Vertigo Software, Inc.\', \'503A Canal Blvd.\', \'Point Richmond\', \'CA\', \'94804\', \'USA\', \'(510) 307-8200\')           

INSERT INTO [Profiles] (
    [Username], [ApplicationName], [IsAnonymous], [LastActivityDate], [LastUpdatedDate]
)
VALUES (
     \'KarinZimprich\', \'.NET Pet Shop 4.0\', 0, GETDATE(), GETDATE()
)
SET @userid = (SELECT @@IDENTITY)
INSERT INTO [Account] ([UniqueID], [Email], [FirstName], [LastName], [Address1], [Address2], [City], [State], [Zip], [Country], [Phone])
     VALUES
           (@userid, \'someone6@microsoft.com\', \'Karin\', \'Zimprich\', \'Vertigo Software, Inc.\', \'503A Canal Blvd.\', \'Point Richmond\', \'CA\', \'94804\', \'USA\', \'(510) 307-8200\')           

INSERT INTO [Profiles] (
    [Username], [ApplicationName], [IsAnonymous], [LastActivityDate], [LastUpdatedDate]
)
VALUES (
     \'RandallBoseman\', \'.NET Pet Shop 4.0\', 0, GETDATE(), GETDATE()
)
SET @userid = (SELECT @@IDENTITY)
INSERT INTO [Account] ([UniqueID], [Email], [FirstName], [LastName], [Address1], [Address2], [City], [State], [Zip], [Country], [Phone])
     VALUES
           (@userid, \'someone7@microsoft.com\', \'Randall\', \'Boseman\', \'Vertigo Software, Inc.\', \'503A Canal Blvd.\', \'Point Richmond\', \'CA\', \'94804\', \'USA\', \'(510) 307-8200\')           

INSERT INTO [Profiles] (
    [Username], [ApplicationName], [IsAnonymous], [LastActivityDate], [LastUpdatedDate]
)
VALUES (
     \'KevinKennedy\', \'.NET Pet Shop 4.0\', 0, GETDATE(), GETDATE()
)
SET @userid = (SELECT @@IDENTITY)
INSERT INTO [Account] ([UniqueID], [Email], [FirstName], [LastName], [Address1], [Address2], [City], [State], [Zip], [Country], [Phone])
     VALUES
           (@userid, \'someone8@microsoft.com\', \'Kevin\', \'Kennedy\', \'Vertigo Software, Inc.\', \'503A Canal Blvd.\', \'Point Richmond\', \'CA\', \'94804\', \'USA\', \'(510) 307-8200\')           

INSERT INTO [Profiles] (
    [Username], [ApplicationName], [IsAnonymous], [LastActivityDate], [LastUpdatedDate]
)
VALUES (
     \'DianeTibbott\', \'.NET Pet Shop 4.0\', 0, GETDATE(), GETDATE()
)
SET @userid = (SELECT @@IDENTITY)
INSERT INTO [Account] ([UniqueID], [Email], [FirstName], [LastName], [Address1], [Address2], [City], [State], [Zip], [Country], [Phone])
     VALUES
           (@userid, \'someone9@microsoft.com\', \'Diane\', \'Tibbott\', \'Vertigo Software, Inc.\', \'503A Canal Blvd.\', \'Point Richmond\', \'CA\', \'94804\', \'USA\', \'(510) 307-8200\')           

INSERT INTO [Profiles] (
    [Username], [ApplicationName], [IsAnonymous], [LastActivityDate], [LastUpdatedDate]
)
VALUES (
     \'GarrettYoung\', \'.NET Pet Shop 4.0\', 0, GETDATE(), GETDATE()
)
SET @userid = (SELECT @@IDENTITY)
INSERT INTO [Account] ([UniqueID], [Email], [FirstName], [LastName], [Address1], [Address2], [City], [State], [Zip], [Country], [Phone])
     VALUES
           (@userid, \'someone10@microsoft.com\', \'Garrett\', \'Young\', \'Vertigo Software, Inc.\', \'503A Canal Blvd.\', \'Point Richmond\', \'CA\', \'94804\', \'USA\', \'(510) 307-8200\')           

INSERT INTO [Profiles] (
    [Username], [ApplicationName], [IsAnonymous], [LastActivityDate], [LastUpdatedDate]
)
VALUES (
     \'demo\', \'.NET Pet Shop 4.0\', 0, GETDATE(), GETDATE()
)
SET @userid = (SELECT @@IDENTITY)
INSERT INTO [Account] ([UniqueID], [Email], [FirstName], [LastName], [Address1], [Address2], [City], [State], [Zip], [Country], [Phone])
     VALUES
           (@userid, \'someone@microsoft.com\', \'Adam\', \'Barr\', \'Vertigo Software, Inc.\', \'503A Canal Blvd.\', \'Point Richmond\', \'CA\', \'94804\', \'USA\', \'(510) 307-8200\')

View Code

?D.2, Sql/DropDBLogin.sql

USE [master]
IF  EXISTS (SELECT * FROM master.dbo.syslogins WHERE name = N\'mspetshop\')
EXEC master.dbo.sp_droplogin @loginame = N\'mspetshop\'

View Code

 

warn 作者：ylbtech
出处：http://ylbtech.cnblogs.com/
本文版权归作者和博客园共有，欢迎转载，但未经作者同意必须保留此段声明，且在文章页面明显位置给出原文连接，否则保留追究法律责任的权利。

版权声明：本文为ylbtech原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://www.cnblogs.com/ylbtech/p/4024030.html