Question

在sql中写了一个T-Sql脚本，执行后建库，建表，建视图，存储过程,在sql中运行正常 现在想要在C#程序中执行

sb = new StringBuilder();
sb.Append("use master");
sb.Append(" if exists(select * from sysdatabases where name='RemPacs_1')");
sb.Append(" drop database RemPacs_1");
sb.Append(" create database RemPacs_1");

sb.Append(" use RemPacs_1");

sb.Append(" if exists(select * from sysobjects where name='GLB_AgeUnit')");
sb.Append(" drop table GLB_AgeUnit");
sb.Append(" create table GLB_AgeUnit");
sb.Append(" (");
sb.Append(" AgeUnitID int not null primary key,");
sb.Append(" [Name] nvarchar(4) not null,");
sb.Append(" DisplayNo int not null");
sb.Append(" )");
sb.Append(" insert into GLB_AgeUnit (AgeUnitID,[Name],DisplayNo) values(1,'岁',1)");
sb.Append(" insert into GLB_AgeUnit (AgeUnitID,[Name],DisplayNo) values(2,'月',2)");
sb.Append(" insert into GLB_AgeUnit (AgeUnitID,[Name],DisplayNo) values(3,'周',3)");
sb.Append(" insert into GLB_AgeUnit (AgeUnitID,[Name],DisplayNo) values(4,'天',4)");
sb.Append(" insert into GLB_AgeUnit (AgeUnitID,[Name],DisplayNo) values(5,'时',5)");
SqlCommand cmd = new SqlCommand(sb.ToString(), GetConnection());
int i = cmd.ExecuteNonQuery();
我这样写的 ，但是建不了

Answer 1

sb = new StringBuilder();
sb.Append(@"use master
if exists(select * from sysdatabases where name='RemPacs_1')
drop database RemPacs_1
create database RemPacs_1
use RemPacs_1
if exists(select * from sysobjects where name='GLB_AgeUnit')
drop table GLB_AgeUnit
create table GLB_AgeUnit
(
AgeUnitID int not null primary key,
[Name] nvarchar(4) not null,
DisplayNo int not null
)
insert into GLB_AgeUnit (AgeUnitID,[Name],DisplayNo) values(1,'岁',1)
insert into GLB_AgeUnit (AgeUnitID,[Name],DisplayNo) values(2,'月',2)
insert into GLB_AgeUnit (AgeUnitID,[Name],DisplayNo) values(3,'周',3)
insert into GLB_AgeUnit (AgeUnitID,[Name],DisplayNo) values(4,'天',4)
insert into GLB_AgeUnit (AgeUnitID,[Name],DisplayNo) values(5,'时',5)");
SqlCommand cmd = new SqlCommand(sb.ToString(), GetConnection());
int i = cmd.ExecuteNonQuery();

Answer 2

l路径 调用。。（传参）

Answer 3

调试一下看看在DBS里查看一下哪里有没有报错

Answer 4

把多语句一起传过去执行，在每个完整的SQL语句后面加上;
否则识别不了

Answer 5

我给你写了个例子 发给你消息了