|
创建一个存储过程:
CREATE PROCEDURE [dbo].[proc_get_Product_By_Price]
??? @minPrice int,
??? @maxPrice int
AS
BEGIN
?SELECT???? xl.id,xl.title,xl.txtmc,xl.fbt,xl.content5,xl.n_fname,xl.mbpath,MIN(jg.crj) AS crj
?FROM???????? pay_order_dd_pro AS jg LEFT OUTER JOIN
??????? order_dd AS xl ON jg.order_dd_id = xl.id
?WHERE???? (xl.lang = 'Chinese') and xl.del<>'1' and xl.shenhe='yes' AND (jg.crj BETWEEN @minprice AND @maxPrice) AND (xl.title <> '')
?GROUP BY jg.order_dd_id,xl.id,xl.mbpath
?ORDER BY crj
END
?
删除存储过程:
drop procedure 存储过程名
?
修改存储过程:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[proc_get_Product_By_Price]
??? @minPrice int,xl.mbpath
?ORDER BY crj
END
?
?
?
?
exec "proc_get_Product_By_Price" 1,1000
在查询工具里调用存储过程? 后面的1,1000是它的两个参数
在asp里调用存储过程 set rs=server.CreateObject("ADODB.Recordset") sql="exec proc_get_Product_By_Price 100,500" rs.open sql,cnzy,1,1 do while not rs.eof ?response.Write rs("title")&"<br>" rs.movenext loop rs.close set rs=nothing
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
