SQL server使用sql语句创建数据库

最新推荐文章于 2024-05-14 19:06:04 发布

Zzu_zzx

最新推荐文章于 2024-05-14 19:06:04 发布

阅读量1k

点赞数

分类专栏： C# 数据库文章标签：数据库 sql sqlserver

本文链接：https://blog.csdn.net/Zzu_zzx/article/details/126878284

版权

C# 同时被 2 个专栏收录

13 篇文章 1 订阅

订阅专栏

数据库

4 篇文章 0 订阅

订阅专栏

 //传入数据库名和连接字符串，创建数据库
        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语句的方法
        }