想将一段ASP代码用一个存储过程实现

2007-04-26 10:11:56 168 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Python数据可视化 -生成数据之绘制折线图和散点图 matplotlib教程https://blog.csdn.net/Notzuonotdied/article/details/77876080 http://study.163.com/course/introduction.htm?courseId=1003240004 matplotlib画廊：https://matplotlib.org/（查看使用matplotlib可制作的各种图表以... 阅读详情

我是想将以下ASP中的代码，转成SQL存储过程，前辈们帮帮忙，学习：

<%
strSql="select id,nsort1,filename from upload where id>1 and id<=1000 order by id"
set rs=conn.Execute(strSql)
if rs_1.eof and rs_1.bof then

else
do while not rs_1.eof
select case rs_1("nsort1")
case "article"
strSql="select 1 from article where charindex('"&rs_1("filename")&"',word)>0"
case "forum"
strSql="select 1 from bbs_data where charindex('"&rs_1("filename")&"',word)>0"
Case Else
strSql=""
end select
If strSql<>"" then
set rs=server.createobject("adodb.recordset")
rs.open strSql,conn,1,1
If rs.RecordCount>0 Then
strSql=""
Else
conn.execute("update upload set iid=0,types=0 where id="&rs_1("id"))
End If
rs.close:set rs=Nothing
End if
rs_1.movenext
loop
rs_1.close:set rs_1=Nothing
end if
%>

...全文