SqlConnection conn = new SqlConnection(Conn);
SqlCommand cmd = new SqlCommand(comm, conn);//comm=下面的SQL语句
cmd.CommandType = CommandType.Text;
try
{
conn.Open();
cmd.ExecuteScalar();
}
catch (Exception e)
{
string ii = e.Message;
}
conn.Close();
_____________________________________________________________________________CREATE PROCEDURE dbo.AAA
@a bigint
AS
BEGIN
INSERT INTO [AAA]
(a)
VALUES
(@a)
END
GOCREATE PROCEDURE dbo.BBB
@b bigint
AS
BEGIN
SELECT b FROM [mytable] where b=@b
END
GO //如果不要GO,则查询分析器及.NET报PROCEDURE 附近错误.
SqlCommand cmd = new SqlCommand(comm, conn);//comm=下面的SQL语句
cmd.CommandType = CommandType.Text;
try
{
conn.Open();
cmd.ExecuteScalar();
}
catch (Exception e)
{
string ii = e.Message;
}
conn.Close();
_____________________________________________________________________________CREATE PROCEDURE dbo.AAA
@a bigint
AS
BEGIN
INSERT INTO [AAA]
(a)
VALUES
(@a)
END
GOCREATE PROCEDURE dbo.BBB
@b bigint
AS
BEGIN
SELECT b FROM [mytable] where b=@b
END
GO //如果不要GO,则查询分析器及.NET报PROCEDURE 附近错误.
解决方案 »
- 如何在用bindingsource控件和tableadapter控件操作数据库的程序中实现事务提交或回滚
- 打开EXCEL文件出现异常,急!
- 求一正则表达式(汉字)
- 请教一个水晶报表的问题,关于xsd 的 ,但是为何出现提示登陆框
- 有没有办法在已经存在的dataset中将不相同的数据加入到combobox中?
- 有没有这样的快捷键?
- C#WinForm如何获取IIS服务器指定文件夹中所有的文件信息
- 调用.net remoting返回的MarshalByRefObject类型的对象的生命期如何管理?如何释放这类远程对象占用的资源?
- 怎么在当前输入框粘贴文本?
- 如何把二进制流转换成一个结构体?
- 哪里有C#写的论坛源代码下载,最好菜单是树型控件那种,如天涯论坛或者是网易论坛
- 求助:想自己建立个企业内部用的论坛
cmd.CommandType = CommandType.StoredProcedure;
直接把GO换成换行就可以了
@a bigint
AS
INSERT INTO [AAA](a) VALUES(@a)
GOCREATE PROCEDURE dbo.BBB
@b bigint
AS
SELECT b FROM [mytable] where b=@b
GOAAA不能重复名字
string b ="CREATE PROCEDURE dbo.BBB( @b bigint) AS SELECT b FROM [mytable] where b=@b";SqlConnection conn = new SqlConnection(Conn);
conn.Open();
SqlCommand cmd = new SqlCommand(a, conn);
cmd.ExecuteScalar();
cmd = new SqlCommand(b, conn);
cmd.ExecuteScalar();
@a bigint
AS
BEGIN
INSERT INTO [AAA] //手误 应该是 INSERT INTO [MyTable]
(a)
VALUES
(@a)
END
GOCREATE PROCEDURE dbo.BBB
@b bigint
AS
SELECT b FROM [mytable] where b=@b
GO最好是不分,而是一次性的执行,因为是从文件中读出来的.