ASP调用存储过程的技巧

2020-03-20 16:00:22来源:爱站网 阅读 ()

容器云强势上线!快速搭建集群,上万Linux镜像随意使用

互联网中有很多ASP的文章介绍,但是小编发现很多并没有正式实践过,也可能是随着我们不断的改进而有所变化,今天爱站技术频道给大家介绍的是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)?
????.Parameters.Append?.CreateParameter("@description",?adLongVarChar,?_?
????????adParamInput,?2147483647,?description)?

????'Add?Output?Parameters?
????.Parameters.Append?.CreateParameter("@link_id",?adInteger,?adParamOutput,?,?0)?

????'Execute?the?function?
????'If?not?returning?a?recordset,?use?the?adExecuteNoRecords?parameter?option?
????.Execute,?,?adExecuteNoRecords?
????link_id?=?.Parameters("@link_id")?
End?With?

5、存储过程的代码?
Create?PROCEDURE?dbo.sp_InsertArticle?
(?
????@columnist_id?int,?
????@url?varchar(255),?
????@title?varchar(99),?
????@description?text?
???????@link_id?int?OUTPUT?
)?
AS?
BEGIN?
????INSERT?INTO?dbo.t_link????(columnist_id,url,title,description)?
????VALUES?(@columnist_id,@url,@title,@description)?

????SELECT?@link_id?=?@@IDENTITY?
END

相信有了爱站技术频道为你推荐的ASP调用存储过程的技巧之后,一定可以让你在不断学习的时期收益或浅。


原文链接:https://js.aizhan.com/develop/asp/12205.html
如有疑问请与原作者联系

标签:ASP存储

版权申明:本站文章部分自网络,如有侵权,请联系:west999com@outlook.com
特别注意:本站所有转载文章言论不代表本站观点,本站所提供的摄影照片,插画,设计作品,如需使用,请与原作者联系,版权归原作者所有

上一篇:Asp中使用JQuery的AJAX提交中文乱码解决方法

下一篇:ASP提速技巧 推荐