文本文件里面的内容为:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Finance_Test]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Finance_Test]
GOSET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GOCREATE PROCEDURE Finance_Test AS
RETURN 33333GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Finance_Test]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Finance_Test]
GOSET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GOCREATE PROCEDURE Finance_Test AS
RETURN 33333GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
怎么写SQL SERVER 我也不清楚,呵呵
我只会ORACLE的,你查查吧
adoquery1.ExecSQL;
“GO”处会出错,
CREATE PROCEDURE Finance_Test AS这一行也会出出错!
TSQL.EXE是什么东西?
s.txt为输出文件
把该文件保存为一个bat文件,运行该文件就行啦嘻嘻
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO可以省略。
CREATE PROCEDURE Finance_Test AS
……
RETURN 33333如果存储过程复杂的话,也会出错,所以还是采用命令行的方式比较省事。我做这个东西是为了给用户打补丁之用。