1.存儲過程的分類
-
系統(tǒng)存儲過程
-
本地存儲過程（用戶自定義）
-
臨時存儲過程（局部【#】、全局【##】臨時存儲過程）
2.創(chuàng)建存儲過程
--選出價格區(qū)間的商品信息create?procedure?sp_goods_price@minprice?float?,@maxprice?floatas?select?*?from?goods? where?price>=@minprice?and?price?<p>執(zhí)行存儲過程： execute sp_goods_price 200 2000</p><p>3.修改存儲過程</p><p class="cnblogs_code"><br></p><pre class="brush:sql;toolbar:false;">create?procedure?sp_goods_betw@minprice?float?=200,@maxprice?float=3000as?select?*?from?goods? where?price>=@minprice?and?price?<p>4.刪除存儲過程</p><p class="cnblogs_code"><br></p><pre class="brush:sql;toolbar:false;">drop?procedure?sp_goods_price
?5.查看存儲過程
sp_helptext?procedureName sp_help?procedureName
?6.重命名存儲過程
exec sp_rename oldName newName
**局部存儲過程
<p style="margin-bottom: 7px;">create procedure #sp_goods_betw@minprice float ,@maxprice floatas select * from goods <br>where price>=@minprice and price </p>
**全局存儲過程
create?procedure?##sp_goods_betw@minprice?float?,@maxprice?floatas?select?*?from?goods? where?price>=@minprice?and?price?<p>**不加緩存的存儲過程</p><p class="cnblogs_code"><br></p><div class="code" style="position:relative; padding:0px; margin:0px;"><pre class="brush:sql;toolbar:false;">???,
with?recompile
as select * from goods where price>=@minprice and price <=@maxpricego
**加密存儲過程
???,
with?enctyption
as?select?*?from?goods? where?price>=@minprice?and?price?
? 版權(quán)聲明
文章版權(quán)歸作者所有，未經(jīng)允許請勿轉(zhuǎn)載。
THE END
