sql语句创建文件夹、判断文件夹、创建数据库、表、

代码

USEmaster;
GOifexists(select*fromsys.databaseswherename='TestDB')
dropdatabaseTestDB
--创建文件夹EXECsp_configure'showadvancedoptions',1GORECONFIGUREGOEXECsp_configure'xp_cmdshell',1RECONFIGUREGOExEcxp_cmdshell'mkdirD:\aaa'--调用DOS命令创建project文件夹
--execxp_cmdshell'rdd:\new/s/q'--删除文件夹
--创建数据库
/**
注意：
1，FILENAME路径；
2，初始化数据库大小和增长方式
**/EXECUTE('CREATEDATABASETestDB
ON
(NAME=TestDB_dat,
FILENAME=''D:\aaa\TestDB.mdf'',
SIZE=500,
MAXSIZE=UNLIMITED,
FILEGROWTH=100)
LOGON
(NAME=TestDB_log,
FILENAME=''D:\aaa\TestDB.ldf'',
SIZE=500,
MAXSIZE=UNLIMITED,
FILEGROWTH=100)'
);

下面是一段判断文件夹是否存在的SQL语句

xp_fileexist: Checks to see if a given file exists or not. It returns three columns with a value of 1 (yes) or 0 (no): File Exists, File is a Directory and Parent Directory Exists.

代码

CREATETABLE#tmp([FileExists]BIT,[FileisaDirectory]BIT,[ParentDirectoryExists]BIT)
INSERTINTO#tmp([FileExists],[FileisaDirectory],[ParentDirectoryExists])
EXECmaster.dbo.xp_fileexist'D:\aaa'SELECT*FROM#tmp
DROPTABLE#tmp