如何使用C＃来运行SQL脚本 [英] How to run a sql script using C#

问题描述

我有一个SQL脚本来创建一个新的数据库，我需要的是安装了我们的产品时创造。为了这个，我需要使用C＃来触发脚本。 DB是SQL-Server 2005 Express的。 PLZ帮助....

SQL脚本如下：

 使用[大师] 
 GO 
 / ******对象：数据库[洁]脚本日期：02/12/2010 11时01分25秒****** / 
 CREATE DATABASE [洁]主
（NAME = N'Jai'，FILENAME = N'C：\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Jai密度纤维板'，SIZE = 3072KB，MAXSIZE = UNLIMITED，FILEGROWTH = 1024KB）
 LOG ON 
（NAME = N'Jai_log'，FILENAME = N'C：\Program Files\Microsoft SQL Server\\ \\MSSQL.1\MSSQL\DATA\Jai_log.ldf'，SIZE = 1024KB，MAXSIZE = 2048GB，FILEGROWTH = 10％）
 COLLATE SQL_Latin1_General_CP1_CI_AS 
 GO 
 EXEC dbo.sp_dbcmptlevel @ DBNAME = N'Jai'，@ new_cmptlevel = 90 
 GO 
如果（1 = FULLTEXTSERVICEPROPERTY（'IsFullTextInstalled'））
开始
 EXEC [洁] [DBO]。[ sp_fulltext_database] @Action ='禁用'
端
 GO 
 ALTER DATABASE [洁] SET ANSI_NULL_DEFAULT OFF 
 GO 
 ALTER DATABASE [洁] SET ANSI_NULLS OFF 
移动到
 ALTER DATABASE [洁] SET ANSI_PADDING OFF 
 GO 
 ALTER DATABASE [洁] SET ANSI_WARNINGS OFF 
 GO 
 ALTER DATABASE [洁] SET ARITHABORT OFF 
 GO 
 ALTER DATABASE [洁] SET AUTO_CLOSE OFF 
 GO 
 ALTER DATABASE [洁] SET AUTO_CREATE_STATISTICS ON 
 GO 
 ALTER DATABASE [洁] SET AUTO_SHRINK OFF 
移动到
 ALTER DATABASE [洁] SET AUTO_UPDATE_STATISTICS ON 
 GO 
 ALTER DATABASE [洁] SET CURSOR_CLOSE_ON_COMMIT OFF 
 GO 
 ALTER DATABASE [洁] SET CURSOR_DEFAULT GLOBAL 
 GO 
 ALTER DATABASE [洁] SET CONCAT_NULL_YIELDS_NULL OFF 
 GO 
 ALTER DATABASE [洁] SET NUMERIC_ROUNDABORT OFF 
 GO 
 ALTER DATABASE [洁] SET QUOTED_IDENTIFIER OFF 
 GO 
 ALTER DATABASE [洁] SET RECURSIVE_TRIGGERS OFF 
 GO 
 ALTER DATABASE [洁] SET ENABLE_BROKER 
 GO 
 ALTER DATABASE SET AUTO_UPDATE_STATISTICS_ASYNC [洁] OFF 
 GO 
 ALTER DATABASE [洁] SET DATE_CORRELATION_OPTIMIZATION OFF 
 GO 
 ALTER DATABASE [洁] SET TRUSTWORTHY OFF 
 GO 
 ALTER DATABASE [洁] SET ALLOW_SNAPSHOT_ISOLATION OFF 
 GO 
 ALTER DATABASE [洁]集的参数化SIMPLE 
 GO 
 ALTER DATABASE [洁] SET READ_WRITE 
 GO 
 ALTER DATABASE [洁] SET RECOVERY FULL 
 GO 
 ALTER DATABASE [洁] SET MULTI_USER 
 GO 
 ALTER DATABASE [洁] SET PAGE_VERIFY CHECKSUM 
 GO 
 ALTER DATABASE [洁] SET DB_CHAIN​​ING OFF 
  

解决方案

看一看

• 的运行在C＃中.SQL脚本文件


• 的如何使用C＃

$ b $执行.SQL脚本文件
b

I have a sql script to create a new database which i need to create when our product is installed. For this i need to fire the script using c#. DB is sql-server 2005 express. Plz help....

The sql script is as follows:

USE [master]
GO
/****** Object:  Database [Jai]    Script Date: 02/12/2010 11:01:25 ******/
CREATE DATABASE [Jai] ON  PRIMARY 
( NAME = N'Jai', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Jai.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'Jai_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Jai_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
 COLLATE SQL_Latin1_General_CP1_CI_AS
GO
EXEC dbo.sp_dbcmptlevel @dbname=N'Jai', @new_cmptlevel=90
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [Jai].[dbo].[sp_fulltext_database] @action = 'disable'
end
GO
ALTER DATABASE [Jai] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [Jai] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [Jai] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [Jai] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [Jai] SET ARITHABORT OFF 
GO
ALTER DATABASE [Jai] SET AUTO_CLOSE OFF 
GO
ALTER DATABASE [Jai] SET AUTO_CREATE_STATISTICS ON 
GO
ALTER DATABASE [Jai] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [Jai] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [Jai] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [Jai] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [Jai] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [Jai] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [Jai] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [Jai] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [Jai] SET  ENABLE_BROKER 
GO
ALTER DATABASE [Jai] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [Jai] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [Jai] SET TRUSTWORTHY OFF 
GO
ALTER DATABASE [Jai] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE [Jai] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [Jai] SET  READ_WRITE 
GO
ALTER DATABASE [Jai] SET RECOVERY FULL 
GO
ALTER DATABASE [Jai] SET  MULTI_USER 
GO
ALTER DATABASE [Jai] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [Jai] SET DB_CHAINING OFF 

解决方案

Have a look at

• Run a .sql script file in C#
• How to execute an .SQL script file using c#

这篇关于如何使用C＃来运行SQL脚本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！