xuwei.rar_completion_xuwei

use master if exists(select * from sysdatabases where name='shop') drop database shop create database shop on ( name=shopDB, filename='F:\xingkai\App_Data\shopdb.mdf', size=2MB, maxsize=10MB, filegrowth=20% ) log on ( name=shopLog, filename='F:\xingkai\App_Data\shoplog.ldf', size=1MB, filegrowth=1MB ) use shop if exists (select * from sysobjects where name='manager') drop table manager create table manager ( 名称 nvarchar(50) primary key not null, 密码 nvarchar(50) not null, 性别 nvarchar(50), 年龄 int, 联系地址 nvarchar(50), 电子邮箱 nvarchar(50), ) go