SQLservice 数据库 use master go xp_cmdshell 'mkdir d:\project', NO_OUTPUT --创建文件夹project,xp_cmdshell为系统存储过程 --检验数据库是否存在，如果为真，删除此数据库-- IF EXISTS(SELECT NAME FROM master.dbo.SYSDATABASES WHERE NAME=N'stuDB') DROP DATABASE stuDB GO --创建数据库-- CREATE DATABA
stuName varchar(50) not null, stuNo varchar(50) primary key not null, stuSex char(2) default '男' check(stuSex = '男' or stuSex = '女') not null, stuAge int check(stuAge between 15 and 50) not null, stuSeat int identity(1,1) not null, stuAddress varcha
