1. \u8fd9\u4e5f\u662f\u6700\u7b80\u5355\u7684\u65b9\u6cd5,\u4e24\u4e2a\u8f93\u5165\u53c2\u6570\uff0c\u65e0\u8fd4\u56de\u503c\uff1a
\nset connection = server.createobject(“adodb.connection”)
\nconnection.open someDSN
\nConnection.Execute “procname varvalue1, varvalue2”<\/p>\n

\u3000\u3000’\u5c06\u6240\u6709\u5bf9\u8c61\u6e05\u4e3anothing\uff0c\u91ca\u653e\u8d44\u6e90
\nconnection.close
\nset connection = nothing<\/p>\n

\n2. \u5982\u679c\u8981\u8fd4\u56de Recordset \u96c6:
\nset connection = server.createobject(“adodb.connection”)
\nconnection.open someDSN
\nset rs = server.createobject(“adodb.recordset”)
\nrs.Open “Exec procname varvalue1, varvalue2”,connection<\/p>\n

\u3000\u3000’\u5c06\u6240\u6709\u5bf9\u8c61\u6e05\u4e3anothing\uff0c\u91ca\u653e\u8d44\u6e90
\nrs.close
\nconnection.close
\nset rs = nothing
\nset connection = nothing<\/p>\n

\n3. \u4ee5\u4e0a\u4e24\u79cd\u65b9\u6cd5\u90fd\u4e0d\u80fd\u6709\u8fd4\u56de\u503c\uff0c\uff08Recordset\u9664\u5916\uff09\uff0c\u5982\u679c\u8981\u5f97\u5230\u8fd4\u56de\u503c\uff0c\u9700\u8981\u7528Command\u7684\u65b9\u6cd5\u3002
\n\u9996\u5148\u8bf4\u660e\uff0c\u8fd4\u56de\u503c\u6709\u4e24\u79cd\u3002\u4e00\u79cd\u662f\u5728\u5b58\u50a8\u8fc7\u7a0b\u4e2d\u76f4\u63a5return\u4e00\u4e2a\u503c\uff0c\u5c31\u8c61C<\/a>\u548cVB\u7684\u51fd\u6570\u8fd4\u56de\u503c\u90a3\u6837\uff1b\u53e6\u4e00\u79cd\u662f\u53ef\u4ee5\u8fd4\u56de\u591a\u4e2a\u503c\uff0c\u5b58
\n\u50a8\u8fd9\u4e9b\u503c\u7684\u53d8\u91cf\u540d\u79f0\u9700\u8981\u5728\u8c03\u7528\u53c2\u6570\u4e2d\u5148\u884c\u6307\u5b9a\u3002
\n\u8fd9\u4e2a\u4f8b\u5b50\u8981\u5904\u7406\u591a\u79cd\u53c2\u6570\uff0c\u8f93\u5165\u53c2\u6570\uff0c\u8f93\u51fa\u53c2\u6570\uff0c\u8fd4\u56de\u8bb0\u5f55\u96c6\u4ee5\u53ca\u4e00\u4e2a\u76f4\u63a5\u8fd4\u56de\u503c\uff08\u591f\u5168\u4e86\u5427\uff1f\uff09
\n\u5b58\u50a8\u8fc7\u7a0b\u5982\u4e0b\uff1a<\/p>\n

\u3000\u3000use pubs
\nGO<\/p>\n

\u3000\u3000– \u5efa\u7acb\u5b58\u50a8\u8fc7\u7a0b
\ncreate procedure sp_PubsTest<\/p>\n

\u3000\u3000– \u5b9a\u4e49\u4e09\u4e2a\u53c2\u6570\u53d8\u91cf\uff0c\u6ce8\u610f\u7b2c\u4e09\u4e2a\uff0c\u7279\u522b\u6807\u8bb0\u662f\u7528\u4e8e\u8f93\u51fa
\n@au_lname varchar (20),
\n@intID int,
\n@intIDOut int OUTPUT<\/p>\n

\u3000\u3000AS<\/p>\n

\u3000\u3000SELECT @intIDOut = @intID + 1<\/p>\n

\u3000\u3000SELECT *
\nFROM authors
\nWHERE au_lname LIKE @au_lname + ‘%’<\/p>\n

\u3000\u3000–\u76f4\u63a5\u8fd4\u56de\u4e00\u4e2a\u503c
\nRETURN @intID + 2<\/p>\n

\n\u8c03\u7528\u8be5\u5b58\u50a8\u8fc7\u7a0b\u7684asp\u7a0b\u5e8f\u5982\u4e0b\uff1a<\/p>\n

\u3000\u3000<%@ Language=VBScript %>
\n<%
\nDim CmdSP
\nDim adoRS
\nDim adCmdSPStoredProc
\nDim adParamReturnValue
\nDim adParaminput
\nDim adParamOutput
\nDim adInteger
\nDim iVal
\nDim oVal
\nDim adoField
\nDim adVarChar<\/p>\n

\u3000\u3000\u2018\u8fd9\u4e9b\u503c\u5728 VB \u4e2d\u662f\u9884\u5b9a\u4e49\u5e38\u91cf\uff0c\u53ef\u4ee5\u76f4\u63a5\u8c03\u7528\uff0c\u4f46\u5728 VBScript \u4e2d\u6ca1\u6709\u9884\u5b9a\u4e49
\nadCmdSPStoredProc = 4
\nadParamReturnValue = 4
\nadParaminput = 1
\nadParamOutput = 2
\nadInteger = 3
\nadVarChar = 200<\/p>\n

\u3000\u3000iVal = 5
\noVal = 3<\/p>\n

\u3000\u3000’\u5efa\u4e00\u4e2acommand\u5bf9\u8c61
\nset CmdSP = Server.CreateObject(“ADODB.Command”)<\/p>\n

\u3000\u3000’\u5efa\u7acb\u8fde\u7ed3
\nCmdSP.ActiveConnection = “Driver={SQL Server};server=(local);Uid=sa;Pwd=;Database=Pubs”<\/p>\n

\u3000\u3000’\u5b9a\u4e49command \u5bf9\u8c61\u8c03\u7528\u540d\u79f0
\nCmdSP.CommandText = “sp_PubsTest”<\/p>\n

\u3000\u3000’\u8bbe\u7f6ecommand\u8c03\u7528\u7c7b\u578b\u662f\u5b58\u50a8\u8fc7\u7a0b (adCmdSPStoredProc = 4)
\nCmdSP.CommandType = adCmdSPStoredProc<\/p>\n

\u3000\u3000’\u5f80command \u5bf9\u8c61\u4e2d\u52a0\u53c2\u6570
\n‘\u5b9a\u4e49\u5b58\u50a8\u8fc7\u7a0b\u6709\u76f4\u63a5\u8fd4\u56de\u503c\uff0c\u5e76\u4e14\u662f\u4e2a\u6574\u6570\uff0c\u7701\u7f3a\u503c\u662f4
\nCmdSP.Parameters.Append CmdSP.CreateParameter(“RETURN_VALUE”, adInteger, adParamReturnValue, 4)
\n‘\u5b9a\u4e49\u4e00\u4e2a\u5b57\u7b26\u578b\u8f93\u5165\u53c2\u6570
\nCmdSP.Parameters.Append CmdSP.CreateParameter(“@au_lname”, adVarChar, adParaminput, 20, “M”)
\n‘\u5b9a\u4e49\u4e00\u4e2a\u6574\u578b\u8f93\u5165\u53c2\u6570
\nCmdSP.Parameters.Append CmdSP.CreateParameter(“@intID”, adInteger, adParamInput, , iVal)
\n‘\u5b9a\u4e49\u4e00\u4e2a\u6574\u578b\u8f93\u51fa\u53c2\u6570
\nCmdSP.Parameters.Append CmdSP.CreateParameter(“@intIDOut”, adInteger, adParamOutput, oVal)<\/p>\n

\u3000\u3000’\u8fd0\u884c\u5b58\u50a8\u8fc7\u7a0b\uff0c\u5e76\u5f97\u5230\u8fd4\u56de\u8bb0\u5f55\u96c6
\nSet adoRS = CmdSP.Execute<\/p>\n

\n‘\u628a\u6bcf\u4e2a\u8bb0\u5f55\u6253\u5370\u51fa\u6765\uff0c\u5176\u4e2d\u7684\u5b57\u6bb5\u662f\u865a\u62df\u7684\uff0c\u53ef\u4ee5\u4e0d\u7528\u7ba1
\nWhile Not adoRS.EOF<\/p>\n

\u3000\u3000for each adoField in adoRS.Fields
\nResponse.Write adoField.Name & “=” & adoField.Value & “<br>” & vbCRLF
\nNext
\nResponse.Write “<br>”
\nadoRS.MoveNext
\nWend<\/p>\n

\u3000\u3000’\u6253\u5370\u4e24\u4e2a\u8f93\u51fa\u503c\uff1a
\nResponse.Write “<p>@intIDOut = \u201c & CmdSP.Parameters(“@intIDOut”).Value & “<\/p>”
\nResponse.Write “<p>Return value = ” & CmdSP.Parameters(“RETURN_VALUE”).Value & “<\/p>”<\/p>\n

\n‘\u5927\u626b\u9664
\nSet adoRS = nothing
\nSet CmdSP.ActiveConnection = nothing
\nSet CmdSP = nothing
\n%><\/p>\n

\u3000\u3000\u5728asp\u4e2d\u8c03\u7528sql server\u7684\u5b58\u50a8\u8fc7\u7a0b\u53ef\u4ee5\u52a0\u5feb\u7a0b\u5e8f\u8fd0\u884c\u901f\u5ea6<\/p>\n

\u3000\u30001.\u8c03\u7528\u5b58\u50a8\u8fc7\u7a0b\u7684\u4e00\u822c\u65b9\u6cd5
\n\u5148\u5047\u8bbe\u5728sql server\u4e2d\u6709\u4e00\u5b58\u50a8\u8fc7\u7a0bdt_users\uff1a
\nCREATE PROCEDURE [dbo].[dt_users]\nAS
\nselect * from users
\nreturn
\nGO
\n\u7b2c\u4e00\u79cd\u65b9\u6cd5\u662f\u4e0d\u5229\u7528command\u5bf9\u8c61\uff0c\u76f4\u63a5\u7528recordset\u5bf9\u8c61
\nset rs=server.createobject(“adodb.recordset”)
\nsql=”exec dt_users”
\nrs.open sql,conn,1,1\u00a0 \u8fd9\u6837\u5c31\u53ef
\n\u7b2c\u4e8c\u79cd\u65b9\u6cd5\u662f\u5229\u7528command\u5bf9\u8c61
\nset comm=server.createobject(“adodb.command”)
\ncomm.commantype=4
\nset comm.activeconnection=conn
\ncomm.commandtext=”dbo.dt_users”
\nset rs=server.createobject(“adodb.recordset”)
\nrs.open comm,,1,1<\/p>\n

\u3000\u30002.\u7ed9\u5b58\u50a8\u8fc7\u7a0b\u4f20\u9012\u53c2\u6570
\n\u5982\u679c\u5b58\u50a8\u8fc7\u7a0b\u4e2d\u4e0d\u7528\u53c2\u6570\uff0c\u800c\u662f\u5355\u4e00\u7684sql\u8bed\u53e5\uff0c\u8fd8\u663e\u793a\u4e0d\u51fa\u8c03\u7528\u5b58\u50a8\u8fc7\u7a0b\u7684\u4f18\u52bf\uff01
\n\u6bd4\u5982\u8bf4\u4e00bbs\u7684\u67e5\u8be2\uff0c\u53ef\u4ee5\u6309\u4f5c\u8005\u548c\u4e3b\u9898\u67e5\u8be2\uff01\u5219\u53ef\u4ee5\u5efa\u7acb\u5b58\u50a8\u8fc7\u7a0b\u5982\u4e0b\uff1a
\n\u53c2\u6570keyword\u4e3a\u5173\u952e\u5b57\uff0cchoose\u662f\u9009\u62e9\u67e5\u8be2\u7684\u65b9\u6cd5\u3002
\nCREATE PROCEDURE [dbo].[dt_bbs]\n@keyword varchar(20)=null,
\n@choose int=null
\nas
\nif @choose=1
\nselect * from bbs where name like @keyword
\nelse
\nselect * from bbs where subject like @keyword
\nreturn
\ngo
\n\u8fd9\u6837\u6211\u4eec\u8c03\u7528\u5b58\u50a8\u8fc7\u7a0b\u65f6\u53ea\u9700\u5c06\u53c2\u6570\u4f20\u9012\u8fc7\u53bb\u5c31\u884c\u4e86\uff0c\u800c\u7701\u53bb\u5728asp\u4e2d\u6765\u5199\u4e00\u6bb5\u7a0b\u5e8f
\n\u7528\u7b2c\u4e00\u79cd\u65b9\u6cd5\uff1a
\nset rs=server.createobject(“adodb.recordset”)
\nsql=”exec dt_bbs ‘”&keyword&”‘,”&choose&””
\nrs.open sql,conn,1,1
\n\u7528\u7b2c\u4e8c\u79cd\u65b9\u6cd5:
\nset comm=server.createobject(“adodb.command”)
\ncomm.commantype=4
\ncomm.Parameters.append comm.CreateParameter(“@keyword”,adChar,adParamInput,50,keyword)
\ncomm.Parameters.append comm.CreateParameter(“@keyword”,adInteger,adParamInput,,choose)
\nset comm.activeconnection=conn
\ncomm.commandtext=”dbo.dt_bbs”
\nset rs=server.createobject(“adodb.recordset”)
\nrs.CursorType=3
\nrs.open comm,,1,1<\/p>\n","protected":false},"excerpt":{"rendered":"

1. \u8fd9\u4e5f\u662f\u6700\u7b80\u5355\u7684\u65b9\u6cd5,\u4e24\u4e2a\u8f93\u5165\u53c2\u6570\uff0c\u65e0\u8fd4\u56de\u503c\uff1a set conn...<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37,6],"tags":[44],"class_list":["post-520","post","type-post","status-publish","format-standard","hentry","category-asp","category-6","tag-44"],"_links":{"self":[{"href":"https:\/\/www.01xj.net\/index.php?rest_route=\/wp\/v2\/posts\/520","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.01xj.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.01xj.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.01xj.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.01xj.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=520"}],"version-history":[{"count":1,"href":"https:\/\/www.01xj.net\/index.php?rest_route=\/wp\/v2\/posts\/520\/revisions"}],"predecessor-version":[{"id":521,"href":"https:\/\/www.01xj.net\/index.php?rest_route=\/wp\/v2\/posts\/520\/revisions\/521"}],"wp:attachment":[{"href":"https:\/\/www.01xj.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=520"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.01xj.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=520"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.01xj.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=520"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}