ASP SQL Server Dreamweave网上购书系统

create database BookShop on primary ( name =BookShop1, filename='D:\MSSQL\MSSQL\Data\BookShop1.mdf', size =10MB, Maxsize =1000MB, filegrowth=10MB ), ( name =BookShop2, filename='D:\MSSQL\MSSQL\Data\BookShop2.ndf', size =10MB, Maxsize =1000MB, filegrowth=10MB ), filegroup BookShopGroup1 ( name =BookShop3, filename='E:\Backup\SqlData\BookShop3.ndf', size =10MB, Maxsize =1000MB, filegrowth=10MB ), ( name =BookShop4, filename='E:\Backup\SqlData\BookShop4.ndf', size =10MB, Maxsize =1000MB, filegrowth=10MB ) log on ( name =BookShoplog, filename='D:\MSSQL\MSSQL\Data\BookShop1.ldf', size =10MB, Maxsize =1000MB, filegrowth=10MB ) create table admininfo ( AdminID decimal(9) identity(1,1), Adminname nvarchar(50), PWD nvarchar(50), Constraint Adminname Primary Key(Adminname) ) select * from admininfo