ASP调用存储过程的诀窍

发布时间：2023-09-07 14:29:21 所属栏目：Asp教程来源：

导读：ASP调用存储过程的技巧

1、最简单的如下

Dim objConn

Set objConn = Server.CreateObject("ADOBD.Connection")

objConn.Open Application("Connection_String")

'Ca

ASP调用存储过程的技巧

1、最简单的如下

           Dim objConn

    Set objConn = Server.CreateObject("ADOBD.Connection")

    objConn.Open Application("Connection_String")

    'Call the stored procedure to increment a counter on the page

    objConn.Execute "exec sp_AddHit"

没有参数，没有返回，没有错误处理，就是这个了

2、带参数的一种调用

objConn.Execute "exec sp_AddHit,'http://www.asp001.net', 1"

请注意分割参数，该方法也不返回记录

3、返回记录的

          Dim objConn

    Dim objRs

    Set objConn = Server.CreateObject("ADOBD.Connection")

    Set objRs = Server.CreateObject("ADOBD.Recordset")

    objConn.Open Application("Connection_String")

    'Call the stored procedure to increment a counter on the page

    objRs.Open objConn, "exec sp_ListArticles '1/15/2001'"

    'Loop through recordset and display each article

4、……

          Dim objConn

          Dim objCmd

'Instantiate objects

Set objConn        = Server.CreateObject("ADODB.Connection")

set objCmd        = Server.CreateObject("ADODB.Command")

conn.Open Application("ConnectionString")

With objCmd

    .ActiveConnection = conn 'You can also just specify a connection string here

    .CommandText = "sp_InsertArticle"

    .CommandType = adCmdStoredProc 'Requires the adovbs.inc file or typelib meta tag

    'Add Input Parameters

    .Parameters.Append .CreateParameter("@columnist_id", adDouble, adParamInput, , columnist_id)

    .Parameters.Append .CreateParameter("@url", adVarChar, adParamInput, 255, url)

    .Parameters.Append .CreateParameter("@title", adVarChar, adParamInput, 99, url)

（编辑：聊城站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!