yzd
- 浏览: 1878656 次
- 性别:
- 来自: 北京
-
文章分类
最新评论
-
yeying12：
强大
HTTP协议详解,你所不知道的 -
夏雪纷纷：
据我所知，9月12日有个对于DXperience 2013新功 ...
DXperience 9.1.3 -
Emy：
现在面临第一个坎。。
IT高薪者所具备的人格魅力 -
yangxiutian：
很详细，楼主很会总结。
IE下 z-index 的各种坑 -
idleone：
真心求指教，全选怎么实现
Android开发之ListView，加入CheckBox（复选框），实现选择列表
使用存储过程并返回值与及返回值的获得方法
<p><span style="color: #0000ff;">CREATE</span><span style="color: #000000;"></span><span style="color: #0000ff;">TABLE</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">dbo</span><span style="color: #ff0000;">]</span><span style="color: #000000;">.</span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">Order</span><span style="color: #ff0000;">]</span><span style="color: #000000;">(<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">o_id</span><span style="color: #ff0000;">]</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">bigint</span><span style="color: #ff0000;">]</span><span style="color: #000000;"></span><span style="color: #ff00ff;">IDENTITY</span><span style="color: #000000;">(</span><span style="font-weight: bold; color: #800000;">1</span><span style="color: #000000;">,</span><span style="font-weight: bold; color: #800000;">1</span><span style="color: #000000;">)</span><span style="color: #808080;">NOT</span><span style="color: #000000;"></span><span style="color: #0000ff;">FOR</span><span style="color: #000000;"></span><span style="color: #0000ff;">REPLICATION</span><span style="color: #000000;"></span><span style="color: #808080;">NOT</span><span style="color: #000000;"></span><span style="color: #0000ff;">NULL</span><span style="color: #000000;">,<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">o_buyerid</span><span style="color: #ff0000;">]</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">int</span><span style="color: #ff0000;">]</span><span style="color: #000000;"></span><span style="color: #808080;">NOT</span><span style="color: #000000;"></span><span style="color: #0000ff;">NULL</span><span style="color: #000000;"><br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top">)</span><br><span style="color: red;"><strong>1.OUPUT参数返回值<br></strong><span style="font-family: Verdana;">例： 向Order表插入一条记录,返回其标识<br></span><br><div style="padding-right: 5px; padding-left: 4px; font-size: 13px; padding-bottom: 4px; width: 98%; padding-top: 4px; background-color: #eeeeee; border: #cccccc 1px solid;">
<strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"><span style="color: #0000ff;">CREATE</span><span style="color: #000000;"></span><span style="color: #0000ff;">PROCEDURE</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">dbo</span><span style="color: #ff0000;">]</span><span style="color: #000000;">.</span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">nb_order_insert</span><span style="color: #ff0000;">]</span></strong><strong><span style="color: #000000;">(<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #008000;">@o_buyerid</span><span style="color: #000000;"></span><span style="color: #0000ff;">int</span></strong><strong><span style="color: #000000;">,<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #008000;">@o_id</span><span style="color: #000000;"></span><span style="color: #0000ff;">bigint</span></strong><strong><span style="color: #000000;">OUTPUT<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top">)<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">AS</span></strong><span style="color: #000000;"><br><strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></strong></span><span style="color: #0000ff;"><strong>BEGIN</strong></span><span style="color: #000000;"><br><strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></strong></span><strong><span style="color: #0000ff;">SET</span><span style="color: #000000;">NOCOUNT</span><span style="color: #0000ff;">ON</span></strong><strong><span style="color: #000000;">;<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">BEGIN</span></strong><span style="color: #000000;"><br><strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></strong></span><strong><span style="color: #0000ff;">INSERT</span><span style="color: #000000;"></span><span style="color: #0000ff;">INTO</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">Order</span><span style="color: #ff0000;">]</span></strong><strong><span style="color: #000000;">(o_buyerid)<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">VALUES</span><span style="color: #000000;">(</span><span style="color: #008000;">@o_buyerid</span></strong><strong><span style="color: #000000;">)<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">SET</span><span style="color: #000000;"></span><span style="color: #008000;">@o_id</span><span style="color: #000000;"></span><span style="color: #808080;">=</span><span style="color: #000000;"></span><span style="font-weight: bold; color: #008000;">@@IDENTITY</span></strong><span style="color: #000000;"><br><strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></strong></span><span style="color: #0000ff;"><strong>END</strong></span><span style="color: #000000;"><br><strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></strong></span><span style="color: #0000ff;"><strong>END</strong></span>
</div>
</span><span style="font-family: Verdana;"><span style="font-family: Verdana;"><br>存储过程中获得方法：<br><br><div style="padding-right: 5px; padding-left: 4px; font-size: 13px; padding-bottom: 4px; width: 98%; padding-top: 4px; background-color: #eeeeee; border: #cccccc 1px solid;">
<img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"><span style="color: #0000ff;">DECLARE</span><span style="color: #000000;"></span><span style="color: #008000;">@o_buyerid</span><span style="color: #000000;"></span><span style="color: #0000ff;">int</span><span style="color: #000000;"><br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">DECLARE</span><span style="color: #000000;"></span><span style="color: #008000;">@o_id</span><span style="color: #000000;"></span><span style="color: #0000ff;">bigint</span><span style="color: #000000;"><br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">EXEC</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">nb_order_insert</span><span style="color: #ff0000;">]</span><span style="color: #000000;"></span><span style="color: #008000;">@o_buyerid</span><span style="color: #000000;">,o_id</span><span style="color: #0000ff;">bigint</span>
</div>
<br><span style="font-family: Verdana;"><strong><span style="color: #ff0000;"><span style="font-family: Verdana;"><strong>2.RETURN过程返回值</strong></span></span><br><br></strong>
<div style="padding-right: 5px; padding-left: 4px; font-size: 13px; padding-bottom: 4px; width: 98%; padding-top: 4px; background-color: #eeeeee; border: #cccccc 1px solid;">
<strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"><span style="color: #0000ff;">CREATE</span><span style="color: #000000;"></span><span style="color: #0000ff;">PROCEDURE</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">dbo</span><span style="color: #ff0000;">]</span><span style="color: #000000;">.</span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">nb_order_insert</span><span style="color: #ff0000;">]</span></strong><strong><span style="color: #000000;">(<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #008000;">@o_buyerid</span><span style="color: #000000;"></span><span style="color: #0000ff;">int</span></strong><strong><span style="color: #000000;">,<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #008000;">@o_id</span><span style="color: #000000;"></span><span style="color: #0000ff;">bigint</span></strong><strong><span style="color: #000000;">OUTPUT<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top">)<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">AS</span></strong><span style="color: #000000;"><br><strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></strong></span><span style="color: #0000ff;"><strong>BEGIN</strong></span><span style="color: #000000;"><br><strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></strong></span><strong><span style="color: #0000ff;">SET</span><span style="color: #000000;">NOCOUNT</span><span style="color: #0000ff;">ON</span></strong><strong><span style="color: #000000;">;<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">IF</span><span style="color: #000000;">(</span><span style="color: #808080;">EXISTS</span><span style="color: #000000;">(</span><span style="color: #0000ff;">SELECT</span><span style="color: #000000;"></span><span style="color: #808080;">*</span><span style="color: #000000;"></span><span style="color: #0000ff;">FROM</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">Shop</span><span style="color: #ff0000;">]</span><span style="color: #000000;"></span><span style="color: #0000ff;">WHERE</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">s_id</span><span style="color: #ff0000;">]</span><span style="color: #000000;"></span><span style="color: #808080;">=</span><span style="color: #000000;"></span><span style="color: #008000;">@o_shopid</span></strong><strong><span style="color: #000000;">))<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">BEGIN</span></strong><span style="color: #000000;"><br><strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></strong></span><strong><span style="color: #0000ff;">INSERT</span><span style="color: #000000;"></span><span style="color: #0000ff;">INTO</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">Order</span><span style="color: #ff0000;">]</span></strong><strong><span style="color: #000000;">(o_buyerid)<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">VALUES</span><span style="color: #000000;">(</span><span style="color: #008000;">@o_buyerid</span></strong><strong><span style="color: #000000;">)<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">SET</span><span style="color: #000000;"></span><span style="color: #008000;">@o_id</span><span style="color: #000000;"></span><span style="color: #808080;">=</span><span style="color: #000000;"></span><span style="font-weight: bold; color: #008000;">@@IDENTITY</span></strong><span style="color: #000000;"><br><strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></strong></span><strong><span style="color: #0000ff;">RETURN</span><span style="color: #000000;"></span><span style="font-weight: bold; color: #800000;">1</span></strong><strong><span style="color: #000000;">—插入成功返回1<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">END</span></strong><span style="color: #000000;"><br><strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></strong></span><span style="color: #0000ff;"><strong>ELSE</strong></span><span style="color: #000000;"><br><strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></strong></span><strong><span style="color: #0000ff;">RETURN</span><span style="color: #000000;"></span><span style="font-weight: bold; color: #800000;">0</span></strong><strong><span style="color: #000000;">—插入失败返回0<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">END</span></strong>
</div>
<br><span style="font-family: Verdana;">存储过程中的获取方法<br><div style="padding-right: 5px; padding-left: 4px; font-size: 13px; padding-bottom: 4px; width: 98%; padding-top: 4px; background-color: #eeeeee; border: #cccccc 1px solid;">
<img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"><span style="color: #0000ff;">DECLARE</span><span style="color: #000000;"></span><span style="color: #008000;">@o_buyerid</span><span style="color: #000000;"></span><span style="color: #0000ff;">int</span><span style="color: #000000;"><br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">DECLARE</span><span style="color: #000000;"></span><span style="color: #008000;">@o_id</span><span style="color: #000000;"></span><span style="color: #0000ff;">bigint</span><span style="color: #000000;"><br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">DECLARE</span><span style="color: #000000;"></span><span style="color: #008000;">@result</span><span style="color: #000000;"></span><span style="color: #0000ff;">bit</span><span style="color: #000000;"><br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">EXEC</span><span style="color: #000000;"></span><span style="color: #008000;">@result</span><span style="color: #000000;"></span><span style="color: #808080;">=</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">nb_order_insert</span><span style="color: #ff0000;">]</span><span style="color: #000000;"></span><span style="color: #008000;">@o_buyerid</span><span style="color: #000000;">,o_id</span><span style="color: #0000ff;">bigint</span><span style="color: #000000;"></span>
</div>
<br><span style="font-family: Verdana;"><strong>3.SELECT 数据集返回值<br><br></strong>
<div style="padding-right: 5px; padding-left: 4px; font-size: 13px; padding-bottom: 4px; width: 98%; padding-top: 4px; background-color: #eeeeee; border: #cccccc 1px solid;">
<strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"><span style="color: #0000ff;">CREATE</span><span style="color: #000000;"></span><span style="color: #0000ff;">PROCEDURE</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">dbo</span><span style="color: #ff0000;">]</span><span style="color: #000000;">.</span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">nb_order_select</span><span style="color: #ff0000;">]</span></strong><strong><span style="color: #000000;">(<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #008000;">@o_id</span><span style="color: #000000;"></span><span style="color: #0000ff;">int</span></strong><span style="color: #000000;"><br><strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top">)<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></strong></span><span style="color: #0000ff;"><strong>AS</strong></span><span style="color: #000000;"><br><strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></strong></span><span style="color: #0000ff;"><strong>BEGIN</strong></span><span style="color: #000000;"><br><strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></strong></span><strong><span style="color: #0000ff;">SET</span><span style="color: #000000;">NOCOUNT</span><span style="color: #0000ff;">ON</span></strong><strong><span style="color: #000000;">;<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">SELECT</span><span style="color: #000000;">o_id,o_buyerid</span><span style="color: #0000ff;">FROM</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">Order</span><span style="color: #ff0000;">]</span></strong><span style="color: #000000;"><br><strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></strong></span><strong><span style="color: #0000ff;">WHERE</span><span style="color: #000000;">o_id</span><span style="color: #808080;">=</span><span style="color: #000000;"></span><span style="color: #008000;">@o_id</span></strong><span style="color: #000000;"><br><strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></strong></span><span style="color: #0000ff;"><strong>GO</strong></span>
</div>
<br><span style="font-family: Verdana;"><span style="color: #0000ff;"><span style="font-family: Verdana;">存储过程中的获取方法<br></span>（1）、使用临时表的方法<br><br><div style="padding-right: 5px; padding-left: 4px; font-size: 13px; padding-bottom: 4px; width: 98%; padding-top: 4px; background-color: #eeeeee; border: #cccccc 1px solid;">
<img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"><span style="color: #0000ff;">CREATE</span><span style="color: #000000;"></span><span style="color: #0000ff;">TABLE</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">dbo</span><span style="color: #ff0000;">]</span><span style="color: #000000;">.</span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">Temp</span><span style="color: #ff0000;">]</span><span style="color: #000000;">(<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">o_id</span><span style="color: #ff0000;">]</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">bigint</span><span style="color: #ff0000;">]</span><span style="color: #000000;"></span><span style="color: #ff00ff;">IDENTITY</span><span style="color: #000000;">(</span><span style="font-weight: bold; color: #800000;">1</span><span style="color: #000000;">,</span><span style="font-weight: bold; color: #800000;">1</span><span style="color: #000000;">)</span><span style="color: #808080;">NOT</span><span style="color: #000000;"></span><span style="color: #0000ff;">FOR</span><span style="color: #000000;"></span><span style="color: #0000ff;">REPLICATION</span><span style="color: #000000;"></span><span style="color: #808080;">NOT</span><span style="color: #000000;"></span><span style="color: #0000ff;">NULL</span><span style="color: #000000;">,<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">o_buyerid</span><span style="color: #ff0000;">]</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">int</span><span style="color: #ff0000;">]</span><span style="color: #000000;"></span><span style="color: #808080;">NOT</span><span style="color: #000000;"></span><span style="color: #0000ff;">NULL</span><span style="color: #000000;"><br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top">)<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">INSERT</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">Temp</span><span style="color: #ff0000;">]</span><span style="color: #000000;"></span><span style="color: #0000ff;">EXEC</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">nb_order_select</span><span style="color: #ff0000;">]</span><span style="color: #000000;"></span><span style="color: #008000;">@o_id</span><span style="color: #000000;"><br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top">–这时</span><span style="color: #0000ff;">Temp</span><span style="color: #000000;">就是EXEC执行SELECT后的结果集<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">SELECT</span><span style="color: #000000;"></span><span style="color: #808080;">*</span><span style="color: #000000;"></span><span style="color: #0000ff;">FROM</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">Temp</span><span style="color: #ff0000;">]</span><span style="color: #000000;"><br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">DROP</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">Temp</span><span style="color: #ff0000;">]</span><span style="color: #000000;">—删除临时表</span>
</div>
<br>（2）、速度不怎么样.（不推荐）<br><br><div style="padding-right: 5px; padding-left: 4px; font-size: 13px; padding-bottom: 4px; width: 98%; padding-top: 4px; background-color: #eeeeee; border: #cccccc 1px solid;">
<img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"><span style="color: #0000ff;">SELECT</span><span style="color: #000000;"></span><span style="color: #808080;">*</span><span style="color: #000000;"></span><span style="color: #0000ff;">from</span><span style="color: #000000;"></span><span style="color: #ff00ff;">openrowset</span><span style="color: #000000;">(’provider_name</span><span style="color: #ff0000;">'</span><span style="color: #ff0000;">,</span><span style="color: #ff0000;">'</span><span style="color: #000000;">Trusted_Connection</span><span style="color: #808080;">=</span><span style="color: #000000;">yes’,</span><span style="color: #ff0000;">'</span><span style="color: #ff0000;">execnb_order_select’)</span>
</div>
原文出处：<a href="http://www.cnblogs.com/zm235/archive/2008/05/09/1189622.html">http://www.cnblogs.com/zm235/archive/2008/05/09/1189622.html</a></span></span></span></span></span></span></span></p>
<strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"><span style="color: #0000ff;">CREATE</span><span style="color: #000000;"></span><span style="color: #0000ff;">PROCEDURE</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">dbo</span><span style="color: #ff0000;">]</span><span style="color: #000000;">.</span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">nb_order_insert</span><span style="color: #ff0000;">]</span></strong><strong><span style="color: #000000;">(<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #008000;">@o_buyerid</span><span style="color: #000000;"></span><span style="color: #0000ff;">int</span></strong><strong><span style="color: #000000;">,<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #008000;">@o_id</span><span style="color: #000000;"></span><span style="color: #0000ff;">bigint</span></strong><strong><span style="color: #000000;">OUTPUT<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top">)<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">AS</span></strong><span style="color: #000000;"><br><strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></strong></span><span style="color: #0000ff;"><strong>BEGIN</strong></span><span style="color: #000000;"><br><strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></strong></span><strong><span style="color: #0000ff;">SET</span><span style="color: #000000;">NOCOUNT</span><span style="color: #0000ff;">ON</span></strong><strong><span style="color: #000000;">;<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">BEGIN</span></strong><span style="color: #000000;"><br><strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></strong></span><strong><span style="color: #0000ff;">INSERT</span><span style="color: #000000;"></span><span style="color: #0000ff;">INTO</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">Order</span><span style="color: #ff0000;">]</span></strong><strong><span style="color: #000000;">(o_buyerid)<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">VALUES</span><span style="color: #000000;">(</span><span style="color: #008000;">@o_buyerid</span></strong><strong><span style="color: #000000;">)<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">SET</span><span style="color: #000000;"></span><span style="color: #008000;">@o_id</span><span style="color: #000000;"></span><span style="color: #808080;">=</span><span style="color: #000000;"></span><span style="font-weight: bold; color: #008000;">@@IDENTITY</span></strong><span style="color: #000000;"><br><strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></strong></span><span style="color: #0000ff;"><strong>END</strong></span><span style="color: #000000;"><br><strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></strong></span><span style="color: #0000ff;"><strong>END</strong></span>
</div>
</span><span style="font-family: Verdana;"><span style="font-family: Verdana;"><br>存储过程中获得方法：<br><br><div style="padding-right: 5px; padding-left: 4px; font-size: 13px; padding-bottom: 4px; width: 98%; padding-top: 4px; background-color: #eeeeee; border: #cccccc 1px solid;">
<img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"><span style="color: #0000ff;">DECLARE</span><span style="color: #000000;"></span><span style="color: #008000;">@o_buyerid</span><span style="color: #000000;"></span><span style="color: #0000ff;">int</span><span style="color: #000000;"><br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">DECLARE</span><span style="color: #000000;"></span><span style="color: #008000;">@o_id</span><span style="color: #000000;"></span><span style="color: #0000ff;">bigint</span><span style="color: #000000;"><br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">EXEC</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">nb_order_insert</span><span style="color: #ff0000;">]</span><span style="color: #000000;"></span><span style="color: #008000;">@o_buyerid</span><span style="color: #000000;">,o_id</span><span style="color: #0000ff;">bigint</span>
</div>
<br><span style="font-family: Verdana;"><strong><span style="color: #ff0000;"><span style="font-family: Verdana;"><strong>2.RETURN过程返回值</strong></span></span><br><br></strong>
<div style="padding-right: 5px; padding-left: 4px; font-size: 13px; padding-bottom: 4px; width: 98%; padding-top: 4px; background-color: #eeeeee; border: #cccccc 1px solid;">
<strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"><span style="color: #0000ff;">CREATE</span><span style="color: #000000;"></span><span style="color: #0000ff;">PROCEDURE</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">dbo</span><span style="color: #ff0000;">]</span><span style="color: #000000;">.</span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">nb_order_insert</span><span style="color: #ff0000;">]</span></strong><strong><span style="color: #000000;">(<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #008000;">@o_buyerid</span><span style="color: #000000;"></span><span style="color: #0000ff;">int</span></strong><strong><span style="color: #000000;">,<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #008000;">@o_id</span><span style="color: #000000;"></span><span style="color: #0000ff;">bigint</span></strong><strong><span style="color: #000000;">OUTPUT<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top">)<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">AS</span></strong><span style="color: #000000;"><br><strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></strong></span><span style="color: #0000ff;"><strong>BEGIN</strong></span><span style="color: #000000;"><br><strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></strong></span><strong><span style="color: #0000ff;">SET</span><span style="color: #000000;">NOCOUNT</span><span style="color: #0000ff;">ON</span></strong><strong><span style="color: #000000;">;<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">IF</span><span style="color: #000000;">(</span><span style="color: #808080;">EXISTS</span><span style="color: #000000;">(</span><span style="color: #0000ff;">SELECT</span><span style="color: #000000;"></span><span style="color: #808080;">*</span><span style="color: #000000;"></span><span style="color: #0000ff;">FROM</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">Shop</span><span style="color: #ff0000;">]</span><span style="color: #000000;"></span><span style="color: #0000ff;">WHERE</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">s_id</span><span style="color: #ff0000;">]</span><span style="color: #000000;"></span><span style="color: #808080;">=</span><span style="color: #000000;"></span><span style="color: #008000;">@o_shopid</span></strong><strong><span style="color: #000000;">))<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">BEGIN</span></strong><span style="color: #000000;"><br><strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></strong></span><strong><span style="color: #0000ff;">INSERT</span><span style="color: #000000;"></span><span style="color: #0000ff;">INTO</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">Order</span><span style="color: #ff0000;">]</span></strong><strong><span style="color: #000000;">(o_buyerid)<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">VALUES</span><span style="color: #000000;">(</span><span style="color: #008000;">@o_buyerid</span></strong><strong><span style="color: #000000;">)<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">SET</span><span style="color: #000000;"></span><span style="color: #008000;">@o_id</span><span style="color: #000000;"></span><span style="color: #808080;">=</span><span style="color: #000000;"></span><span style="font-weight: bold; color: #008000;">@@IDENTITY</span></strong><span style="color: #000000;"><br><strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></strong></span><strong><span style="color: #0000ff;">RETURN</span><span style="color: #000000;"></span><span style="font-weight: bold; color: #800000;">1</span></strong><strong><span style="color: #000000;">—插入成功返回1<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">END</span></strong><span style="color: #000000;"><br><strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></strong></span><span style="color: #0000ff;"><strong>ELSE</strong></span><span style="color: #000000;"><br><strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></strong></span><strong><span style="color: #0000ff;">RETURN</span><span style="color: #000000;"></span><span style="font-weight: bold; color: #800000;">0</span></strong><strong><span style="color: #000000;">—插入失败返回0<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">END</span></strong>
</div>
<br><span style="font-family: Verdana;">存储过程中的获取方法<br><div style="padding-right: 5px; padding-left: 4px; font-size: 13px; padding-bottom: 4px; width: 98%; padding-top: 4px; background-color: #eeeeee; border: #cccccc 1px solid;">
<img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"><span style="color: #0000ff;">DECLARE</span><span style="color: #000000;"></span><span style="color: #008000;">@o_buyerid</span><span style="color: #000000;"></span><span style="color: #0000ff;">int</span><span style="color: #000000;"><br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">DECLARE</span><span style="color: #000000;"></span><span style="color: #008000;">@o_id</span><span style="color: #000000;"></span><span style="color: #0000ff;">bigint</span><span style="color: #000000;"><br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">DECLARE</span><span style="color: #000000;"></span><span style="color: #008000;">@result</span><span style="color: #000000;"></span><span style="color: #0000ff;">bit</span><span style="color: #000000;"><br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">EXEC</span><span style="color: #000000;"></span><span style="color: #008000;">@result</span><span style="color: #000000;"></span><span style="color: #808080;">=</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">nb_order_insert</span><span style="color: #ff0000;">]</span><span style="color: #000000;"></span><span style="color: #008000;">@o_buyerid</span><span style="color: #000000;">,o_id</span><span style="color: #0000ff;">bigint</span><span style="color: #000000;"></span>
</div>
<br><span style="font-family: Verdana;"><strong>3.SELECT 数据集返回值<br><br></strong>
<div style="padding-right: 5px; padding-left: 4px; font-size: 13px; padding-bottom: 4px; width: 98%; padding-top: 4px; background-color: #eeeeee; border: #cccccc 1px solid;">
<strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"><span style="color: #0000ff;">CREATE</span><span style="color: #000000;"></span><span style="color: #0000ff;">PROCEDURE</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">dbo</span><span style="color: #ff0000;">]</span><span style="color: #000000;">.</span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">nb_order_select</span><span style="color: #ff0000;">]</span></strong><strong><span style="color: #000000;">(<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #008000;">@o_id</span><span style="color: #000000;"></span><span style="color: #0000ff;">int</span></strong><span style="color: #000000;"><br><strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top">)<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></strong></span><span style="color: #0000ff;"><strong>AS</strong></span><span style="color: #000000;"><br><strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></strong></span><span style="color: #0000ff;"><strong>BEGIN</strong></span><span style="color: #000000;"><br><strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></strong></span><strong><span style="color: #0000ff;">SET</span><span style="color: #000000;">NOCOUNT</span><span style="color: #0000ff;">ON</span></strong><strong><span style="color: #000000;">;<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">SELECT</span><span style="color: #000000;">o_id,o_buyerid</span><span style="color: #0000ff;">FROM</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">Order</span><span style="color: #ff0000;">]</span></strong><span style="color: #000000;"><br><strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></strong></span><strong><span style="color: #0000ff;">WHERE</span><span style="color: #000000;">o_id</span><span style="color: #808080;">=</span><span style="color: #000000;"></span><span style="color: #008000;">@o_id</span></strong><span style="color: #000000;"><br><strong><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></strong></span><span style="color: #0000ff;"><strong>GO</strong></span>
</div>
<br><span style="font-family: Verdana;"><span style="color: #0000ff;"><span style="font-family: Verdana;">存储过程中的获取方法<br></span>（1）、使用临时表的方法<br><br><div style="padding-right: 5px; padding-left: 4px; font-size: 13px; padding-bottom: 4px; width: 98%; padding-top: 4px; background-color: #eeeeee; border: #cccccc 1px solid;">
<img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"><span style="color: #0000ff;">CREATE</span><span style="color: #000000;"></span><span style="color: #0000ff;">TABLE</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">dbo</span><span style="color: #ff0000;">]</span><span style="color: #000000;">.</span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">Temp</span><span style="color: #ff0000;">]</span><span style="color: #000000;">(<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">o_id</span><span style="color: #ff0000;">]</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">bigint</span><span style="color: #ff0000;">]</span><span style="color: #000000;"></span><span style="color: #ff00ff;">IDENTITY</span><span style="color: #000000;">(</span><span style="font-weight: bold; color: #800000;">1</span><span style="color: #000000;">,</span><span style="font-weight: bold; color: #800000;">1</span><span style="color: #000000;">)</span><span style="color: #808080;">NOT</span><span style="color: #000000;"></span><span style="color: #0000ff;">FOR</span><span style="color: #000000;"></span><span style="color: #0000ff;">REPLICATION</span><span style="color: #000000;"></span><span style="color: #808080;">NOT</span><span style="color: #000000;"></span><span style="color: #0000ff;">NULL</span><span style="color: #000000;">,<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">o_buyerid</span><span style="color: #ff0000;">]</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">int</span><span style="color: #ff0000;">]</span><span style="color: #000000;"></span><span style="color: #808080;">NOT</span><span style="color: #000000;"></span><span style="color: #0000ff;">NULL</span><span style="color: #000000;"><br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top">)<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">INSERT</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">Temp</span><span style="color: #ff0000;">]</span><span style="color: #000000;"></span><span style="color: #0000ff;">EXEC</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">nb_order_select</span><span style="color: #ff0000;">]</span><span style="color: #000000;"></span><span style="color: #008000;">@o_id</span><span style="color: #000000;"><br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top">–这时</span><span style="color: #0000ff;">Temp</span><span style="color: #000000;">就是EXEC执行SELECT后的结果集<br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">SELECT</span><span style="color: #000000;"></span><span style="color: #808080;">*</span><span style="color: #000000;"></span><span style="color: #0000ff;">FROM</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">Temp</span><span style="color: #ff0000;">]</span><span style="color: #000000;"><br><img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"></span><span style="color: #0000ff;">DROP</span><span style="color: #000000;"></span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">Temp</span><span style="color: #ff0000;">]</span><span style="color: #000000;">—删除临时表</span>
</div>
<br>（2）、速度不怎么样.（不推荐）<br><br><div style="padding-right: 5px; padding-left: 4px; font-size: 13px; padding-bottom: 4px; width: 98%; padding-top: 4px; background-color: #eeeeee; border: #cccccc 1px solid;">
<img src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif" alt="" align="top"><span style="color: #0000ff;">SELECT</span><span style="color: #000000;"></span><span style="color: #808080;">*</span><span style="color: #000000;"></span><span style="color: #0000ff;">from</span><span style="color: #000000;"></span><span style="color: #ff00ff;">openrowset</span><span style="color: #000000;">(’provider_name</span><span style="color: #ff0000;">'</span><span style="color: #ff0000;">,</span><span style="color: #ff0000;">'</span><span style="color: #000000;">Trusted_Connection</span><span style="color: #808080;">=</span><span style="color: #000000;">yes’,</span><span style="color: #ff0000;">'</span><span style="color: #ff0000;">execnb_order_select’)</span>
</div>
原文出处：<a href="http://www.cnblogs.com/zm235/archive/2008/05/09/1189622.html">http://www.cnblogs.com/zm235/archive/2008/05/09/1189622.html</a></span></span></span></span></span></span></span></p>
分享到：
发表评论
相关推荐
总的来说，VB.NET 2008调用SQL Server存储过程涉及到创建数据库连接、定义命令对象、设置参数、执行存储过程并处理返回值和异常。这个过程允许开发者高效地与数据库交互，同时处理可能发生的错误情况。
即使使用了`RETURN`或`OUTPUT`，存储过程仍然可以返回一个或多个数据集，这些数据集可以通过`SELECT`语句生成，并在调用者处通过数据适配器或其他方式处理。 综上所述，`RETURN`和`OUTPUT`在Mssql存储过程中的应用...
标题“关于有返回值的存储过程”着重提到了具有返回值这一特性，这通常指的是存储过程可以返回一个或多个结果以供后续操作使用。 存储过程具有返回值的主要好处包括提高性能、增强安全性、降低网络流量以及提供更好...
总之，这篇博文可能会详细解释如何使用自定义SqlHelper类来高效、安全地调用存储过程，并演示如何获取存储过程的输出参数和返回值，这对于任何.NET开发者来说都是非常实用的知识。在实际开发中，掌握这类技术能够...
java调用存储过程，支持获取return值，output返回值，以及查询的表数据，表数据允许有多个查询结果集
在Python编程中，调用MySQL数据库的存储过程并获取返回值是常见的操作，尤其是在执行复杂的数据库操作时。这里我们将详细探讨如何使用Python的`MySQLdb`库来完成这个任务。 首先，确保你已经安装了`MySQLdb`库，...
本文实例讲述了Python中执行存储过程及获取存储过程返回值的方法。分享给大家供大家参考，具体如下： 在Pathon中如何执行存储过程呢？可以使用如下方法： 存储过程定义基本如下： ALTER procedure [dbo]. [mysp] @...
创建存储过程： ALTER PROCEDURE [dbo].[GetCustomers] (@rowcount INT OUTPUT) AS SELECT [CustomerID] ,[CompanyName] ,[ContactName] ,[ContactTitle] ,[Address] ,[City] ,[Region] ,[PostalCode] ,...
本示例将讲解如何在C#应用程序中调用存储过程获取返回值，并利用这些值在DataGridView控件中实现数据的批量删除操作。 首先，我们需要在数据库（如SQL Server）中创建一个存储过程，例如名为`usp_BatchDelete`。这...
本篇将深入探讨如何使用JDBC来调用Oracle的存储过程并处理返回值。 首先，了解存储过程的概念。存储过程是预编译的SQL语句集合，它们存储在数据库服务器中，可以接受参数，执行一系列操作，并可能返回结果。在...
在Java编程中，调用MySQL存储过程并获取返回值是一项常见的任务，这有助于优化数据库操作，提高代码的可维护性和性能。以下是如何使用Java来执行这个操作的详细步骤和相关知识点： 1. **连接数据库**： 在Java中，...
调用存储过程并获取返回值，可以使用`ExecuteNonQuery()`方法。在执行存储过程后，返回值通常会通过`MySqlCommand`的`Scalar`属性获取： ```vb.net Dim returnValue As Object = myCommand.ExecuteScalar() ``` `...
本文将详细介绍PHP调用MySQL存储过程并获取返回值的方法，并提供使用技巧。 首先，存储过程的创建可以使用以下MySQL语句： ```sql mysql> delimiter // mysql> CREATE PROCEDURE employee_list(OUT param1 INT) -...
然而，Python的`threading`模块本身并不直接支持获取线程函数的返回值，这需要我们通过一些额外的方式来实现。以下将详细解释如何在Python中使用`threading`获取线程函数的返回值。 首先，我们需要理解`threading`...
本文实例讲述了C#调用存储过程的方法。分享给大家供大家参考，具体如下： CREATE PROCEDURE [dbo].[GetNameById] @studentid varchar(8), @studentname nvarchar(50) OUTPUT AS BEGIN SELECT @studentname=...
本篇将详细解释一个具体的示例，通过VB6.0来调用一个名为`ADOTestRPE`的存储过程，并测试其返回值、输入参数以及输出参数。 #### 一、准备工作 为了实现这个功能，我们需要准备以下几个组件： 1. **连接对象**：...
本文将详细介绍C#如何使用存储过程，以及如何接收SQL存储过程的返回值。 首先，存储过程（Stored Procedure）是一组预编译的SQL语句，它在数据库服务器上预先定义并存储，可以被多次调用执行，降低了网络通信的负担...
VB.Net调用存储过程并得到返回值 ...本文给出了VB.Net调用存储过程并得到返回值的代码示例，通过ADO.NET框架，我们可以轻松地调用存储过程并获得返回值。同时，我们也可以通过错误处理来提高代码的可靠性和稳定性。