//传入数据库名和连接字符串,创建数据库
private void createDataBase(string dbName, string connStr)
{
string mainFileName = dbName + "MAINDATAFILE";
string logoName = dbName + "LOGDATAFLIE";
string sqlStr = "CREATE DATABASE " + dbName;
sqlStr += " ON ";
sqlStr += " (NAME = " + mainFileName + ", ";
sqlStr += " FILENAME = 'D:\\" + mainFileName + ".mdf', ";
sqlStr += " SIZE = 8, ";
sqlStr += " MAXSIZE = UNLIMITED, ";
sqlStr += " FILEGROWTH = 1024KB) ";
sqlStr += " LOG ON ";
sqlStr += " (NAME= " + logoName + ", ";
sqlStr += " FILENAME= 'D:\\" + logoName + ".ldf', ";
sqlStr += " SIZE= 8, ";
sqlStr += " MAXSIZE= 2048GB, ";
sqlStr += " FILEGROWTH = 10%) ";
SqlParameter[] ps = new SqlParameter[] { };
ExecuteNonQuery(connStr, sqlStr, ps);//执行sql语句的方法
}
SQL server使用sql语句创建数据库
最新推荐文章于 2024-08-07 22:07:28 发布