注册 登录
编程论坛 ASP技术论坛

有关用ASP创建存储过程的问题

lazich 发布于 2008-08-07 19:49, 996 次点击
我想用ASP语言在SQL创建一条存储过程
存储过程代码如下:
SET   QUOTED_IDENTIFIER     OFF         SET   ANSI_NULLS     OFF     
  GO   
   
  exec(decrypt(0x05DFAFE2CFEB612D27068F4678A6CF8BD2046DC11CF8896F31FA1CD6D114421A50FB05B7A8B035F532B992F6F41A6C149290C50D8A604BC34FAE736C7462775A169025BBBC7207C19C78382DF3CFAB7DBE97E96F92493D99F0E384EC09F1917AB016EC63E98A5FC2D63491D61F0DA91702BCAC3921D43A69C534F4AADAC320FE961121E58262A36909BDDA4A28A5F4B881E1F0D80D37C62D60736490356FDD564109886C5359E1846D4997EFDF23742DC9B4C8BCB3949DE6A6D3210AFBE94817527191733E788D35C97CBFB99C9B6BC3859FEC70B9283377526C886D9836F96ECCF2D14C6B102404F4A4EEBD9E8187E66835E475EF7408205C09ED4FF2B73A3E0254C0AD638E021CF58DBC9B9A4CC232F9700699667CFEDDD093AC9CF08FCB85BF867E251F80F71871A88BF794F92C602BC1D3AA01FF4F17EE40367C80CBA38744AC9395D4C39714E28967A19B43FC745BD141D6A96198F33E3D081E58A426CF44276DBE7F72361795A5167C   
  ))   
  GO   
  SET   QUOTED_IDENTIFIER     OFF         SET   ANSI_NULLS     ON     
  GO



可我用ASP执行时,老是提示出错,请问高手如何解决?

附送部分代码如下:

<!--#include file="conn.asp"-->
<!--#include file="inc/const.asp"-->
<%
Dim StrSQL
StrSQL="SET   QUOTED_IDENTIFIER     OFF         SET   ANSI_NULLS     OFF     
  GO   
   
  exec(decrypt(0x05DFAFE2CFEB612D27068F4678A6CF8BD2046DC11CF8896F31FA1CD6D114421A50FB05B7A8B035F532B992F6F41A6C149290C50D8A604BC34FAE736C7462775A169025BBBC7207C19C78382DF3CFAB7DBE97E96F92493D99F0E384EC09F1917AB016EC63E98A5FC2D63491D61F0DA91702BCAC3921D43A69C534F4AADAC320FE961121E58262A36909BDDA4A28A5F4B881E1F0D80D37C62D60736490356FDD564109886C5359E1846D4997EFDF23742DC9B4C8BCB3949DE6A6D3210AFBE94817527191733E788D35C97CBFB99C9B6BC3859FEC70B9283377526C886D9836F96ECCF2D14C6B102404F4A4EEBD9E8187E66835E475EF7408205C09ED4FF2B73A3E0254C0AD638E021CF58DBC9B9A4CC232F9700699667CFEDDD093AC9CF08FCB85BF867E251F80F71871A88BF794F92C602BC1D3AA01FF4F17EE40367C80CBA38744AC9395D4C39714E28967A19B43FC745BD141D6A96198F33E3D081E58A426CF44276DBE7F72361795A5167C   
  ))   
  GO   
  SET   QUOTED_IDENTIFIER     OFF         SET   ANSI_NULLS     ON     
  GO
"
Conn.Execute StrSQL
Response.Write "创建存储过程成功"
Conn.close: Set Cnn = Nothing
%>

红色部分接入无法执行.
7 回复
#2
yms1232008-08-07 20:30
https://bbs.bccn.net/viewthread.php?tid=156082&extra=page%3D2%26amp%3Bfilter%3Ddigest
楼主这个问题精华帖子里已经有解答了,上面的地址是精华帖子里ASP创建和使用存储过程的教程
#3
yms1232008-08-07 20:31
而且conn.execute方法是不能创建存储过程的。
在ASP里创建存储过程要使用对象,不能使用ADODB.Connection对象
#4
lazich2008-08-07 20:49
已经按照三楼的做法了

按照这样:
<!--#include file="conn1.asp"-->
<!--#include file="inc/const.asp"-->
<%
Dim StrSQL
StrSQL="SET QUOTED_IDENTIFIER  OFF SET   ANSI_NULLS  OFF exec(decrypt(0x05DFAFE2CFEB612D27068F4678A6CF8BD2046DC11CF8896F31FA1CD6D114421A50FB05B7A8B035F532B992F6F41A6C149290C50D8A604BC34FAE736C7462775A169025BBBC7207C19C78382DF3CFAB7DBE97E96F92493D99F0E384EC09F1917AB016EC63E98A5FC2D63491D61F0DA91702BCAC3921D43A69C534F4AADAC320FE961121E58262A36909BDDA4A28A5F4B881E1F0D80D37C62D60736490356FDD564109886C5359E1846D4997EFDF23742DC9B4C8BCB3949DE6A6D3210AFBE94817527191733E788D35C97CBFB99C9B6BC3859FEC70B9283377526C886D9836F96ECCF2D14C6B102404F4A4EEBD9E8187E66835E475EF7408205C09ED4FF2B73A3E0254C0AD638E021CF58DBC9B9A4CC232F9700699667CFEDDD093AC9CF08FCB85BF867E251F80F71871A88BF794F92C602BC1D3AA01FF4F17EE40367C80CBA38744AC9395D4C39714E28967A19B43FC745BD141D6A96198F33E3D081E58A426CF44276DBE7F72361795A5167C )) SET  QUOTED_IDENTIFIER  OFF SET   ANSI_NULLS ON
GO "
Conn.Execute StrSQL
Response.Write "创建存储过程成功"
Conn.close: Set Cnn = Nothing
%>

提示缺少对象
#5
lazich2008-08-07 20:52
另一种在SQL执行语句为:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Dv_TSQL]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Dv_TSQL]
GO

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO

/****** Encrypted object is not transferable, and script can not be generated. ******/

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
#6
lele20072008-08-07 22:50
请问下!这样作有什么用的?
#7
lazich2008-08-07 22:57
目的是为了创建一个名为:Dv_TSQL的存储过程.

在ASP下创建.
#8
yms1232008-08-08 09:49
Conn这个对象是类型的?
1