我想用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
%>

红色部分接入无法执行.

https://bbs.bccn.net/viewthread.php?tid=156082&extra=page%3D2%26amp%3Bfilter%3Ddigest
楼主这个问题精华帖子里已经有解答了，上面的地址是精华帖子里ASP创建和使用存储过程的教程

而且conn.execute方法是不能创建存储过程的。
在ASP里创建存储过程要使用对象，不能使用ADODB.Connection对象

已经按照三楼的做法了

按照这样:
<!--#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
%>

提示缺少对象

另一种在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

请问下！这样作有什么用的？

目的是为了创建一个名为:Dv_TSQL的存储过程.

在ASP下创建.

Conn这个对象是类型的？