USE master
GO
EXEC xp_cmdshell 'mkdir d:\PGM Project\Stu_Examination_System\DB', NO_OUTPUT
/*$$$$$$$$$$$$$建库$$$$$$$$$$$$$$$$$$$$$$$$*/
--检验数据库是否存在,如果为真,删除此数据库--
IF exists(SELECT * FROM sysdatabases WHERE name='SEXAM_SystemDB')
DROP DATABASE SEXAM_SystemDB
GO
--创建建库SEXAM_SystemDB
CREATE DATABASE SEXAM_SystemDB
ON
(
NAME='SEXAM_SystemDB_data',
FILENAME='d:\PGM Project\Stu_Examination_System\DB\SEXAM_SystemDB_data.mdf',
SIZE=3mb,
FILEGROWTH=15%
)
LOG ON
(
NAME= 'SEXAM_SystemDB_log',
FILENAME='d:\PGM Project\Stu_Examination_System\DB\SEXAM_SystemDB_log.ldf',
SIZE=3mb,
FILEGROWTH=15%
)
GO
/*$$$$$$$$$$$$$建表$$$$$$$$$$$$$$$$$$$$$$$$*/
USE SEXAM_SystemDB
不理解哪里错了