27,579
社区成员
发帖
与我相关
我的任务
分享
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
namespace ConsoleApplication12
{
class Program
{
static void Main(string[] args)
{
//连接串,注:权限要足够,否则创建不了数据库
string connString = @"Data Source=.\sqlserver2005;Initial Catalog=master;Integrated Security=True";
//创建数据库的SQL, 注:对应路径要存在,而且没有同名的库和文件
string sql =
@"CREATE DATABASE [testDb] ON PRIMARY
( NAME = N'testDb', FILENAME = N'D:\database\2005\testDb.mdf' , SIZE = 3072KB , FILEGROWTH = 8192KB )
LOG ON
( NAME = N'testDb_log', FILENAME = N'D:\database\2005\testDb_log.ldf' , SIZE = 1024KB , FILEGROWTH = 8192KB )";
string sql_Exists =
@"IF EXISTS(SELECT * FROM sys.databases AS d WHERE d.name='testDb')
SELECT 1 AS r
ELSE
SELECT 0 AS r
";
try
{
using (SqlConnection conn = new SqlConnection(connString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql_Exists, conn);
if (cmd.ExecuteScalar().ToString() == "1")
{
Console.WriteLine("数据库已存在,不作创建操作!");
}
else
{
Console.WriteLine("数据库不存在,开始创建...");
cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
Console.WriteLine("创建成功。");
}
}
}
catch (Exception ex)
{
Console.WriteLine("执行失败:" + ex.Message);
}
Console.Read();
}
}
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
namespace ConsoleApplication12
{
class Program
{
static void Main(string[] args)
{
//连接串,注:权限要足够,否则创建不了数据库
string connString = @"Data Source=.\sqlserver2005;Initial Catalog=master;Integrated Security=True";
//创建数据库的SQL, 注:对应路径要存在,而且没有同名的库和文件
string sql =
@"CREATE DATABASE [testDb] ON PRIMARY
( NAME = N'testDb', FILENAME = N'D:\database\2005\testDb.mdf' , SIZE = 3072KB , FILEGROWTH = 8192KB )
LOG ON
( NAME = N'testDb_log', FILENAME = N'D:\database\2005\testDb_log.ldf' , SIZE = 1024KB , FILEGROWTH = 8192KB )";
try
{
using (SqlConnection conn = new SqlConnection(connString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
Console.WriteLine("创建成功。");
}
}
catch (Exception ex)
{
Console.WriteLine("创建失败:" + ex.Message);
}
Console.Read();
}
}
}