锘??xml version="1.0" encoding="utf-8" standalone="yes"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/"><channel><title>&#20037;&#20037;&#19968;&#26412;&#32508;&#21512;&#44;&#20037;&#20037;&#20037;&#20037;&#20037;&#97;&#118;&#44;&#22269;&#20135;&#20813;&#36153;&#35266;&#30475;&#20037;&#20037;</title><link>http://www.aygfsteel.com/BeyondBoyxb/</link><description /><language>zh-cn</language><lastBuildDate>Fri, 20 Jun 2025 00:49:05 GMT</lastBuildDate><pubDate>Fri, 20 Jun 2025 00:49:05 GMT</pubDate><ttl>60</ttl><item><title>鍒╃敤SQL Server鐨勫叏灞�涓存椂琛ㄩ槻姝㈢敤鎴烽噸澶嶇櫥褰?/title><link>http://www.aygfsteel.com/BeyondBoyxb/archive/2007/09/25/147987.html</link><dc:creator>BeyondBoy</dc:creator><author>BeyondBoy</author><pubDate>Tue, 25 Sep 2007 02:12:00 GMT</pubDate><guid>http://www.aygfsteel.com/BeyondBoyxb/archive/2007/09/25/147987.html</guid><wfw:comment>http://www.aygfsteel.com/BeyondBoyxb/comments/147987.html</wfw:comment><comments>http://www.aygfsteel.com/BeyondBoyxb/archive/2007/09/25/147987.html#Feedback</comments><slash:comments>1</slash:comments><wfw:commentRss>http://www.aygfsteel.com/BeyondBoyxb/comments/commentRss/147987.html</wfw:commentRss><trackback:ping>http://www.aygfsteel.com/BeyondBoyxb/services/trackbacks/147987.html</trackback:ping><description><![CDATA[<div>
<p>create procedure gp_findtemptable<br />
<br />
/* <span style="font-family: 瀹嬩綋">瀵繪壘浠ユ搷浣滃憳宸ュ彿鍛藉悕鐨勫叏灞�涓存椂琛?/span></p>
<p>&nbsp;* <span style="font-family: 瀹嬩綋">濡傛棤鍒欏皢</span>out<span style="font-family: 瀹嬩綋">鍙傛暟緗負(fù)</span>0<span style="font-family: 瀹嬩綋">騫跺垱寤鴻琛?/span>,<span style="font-family: 瀹嬩綋">濡傛湁鍒欏皢</span>out<span style="font-family: 瀹嬩綋">鍙傛暟緗負(fù)</span>1 </p>
<p>&nbsp;* <span style="font-family: 瀹嬩綋">鍦?/span>connection<span style="font-family: 瀹嬩綋">鏂紑榪炴帴鍚?/span>,<span style="font-family: 瀹嬩綋">鍏ㄥ眬涓存椂琛ㄤ細(xì)琚?/span>SQL Server<span style="font-family: 瀹嬩綋">鑷姩鍥炴敹</span></p>
<p style="margin-left: 6pt">* <span style="font-family: 瀹嬩綋">濡傚彂鐢熸柇鐢?shù)涔嬀c葷殑鎰忓</span>,<span style="font-family: 瀹嬩綋">鍏ㄥ眬涓存椂琛ㄨ櫧鐒惰繕瀛樺湪浜?/span>tempdb<span style="font-family: 瀹嬩綋">涓?/span>,<span style="font-family: 瀹嬩綋">浣嗘槸宸茬粡澶卞幓媧繪�?/span></p>
<p style="margin-left: 6pt">* <span style="font-family: 瀹嬩綋">鐢?/span>object_id<span style="font-family: 瀹嬩綋">鍑芥暟鍘誨垽鏂椂浼?xì)璁や负鍏朵笉瀛樺?/span>.</p>
<p>&nbsp;*/</p>
<p>@v_userid varchar(6), -- <span style="font-family: 瀹嬩綋">鎿嶄綔鍛樺伐鍙?/span></p>
<p>@i_out int out -- <span style="font-family: 瀹嬩綋">杈撳嚭鍙傛暟</span> 0:<span style="font-family: 瀹嬩綋">娌℃湁鐧誨綍</span> 1:<span style="font-family: 瀹嬩綋">宸茬粡鐧誨綍</span></p>
<p>as</p>
<p>declare @v_sql varchar(100)</p>
<p>if object_id('tempdb.dbo.##'+@v_userid) is null</p>
<p>begin</p>
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; set @v_sql = 'create table ##'+@v_userid+'(userid varchar(6))'</p>
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; exec (@v_sql)</p>
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; set @i_out = 0</p>
<p>end</p>
<p>else</p>
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; set @i_out = 1</p>
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span style="font-family: 瀹嬩綋">鍦ㄨ繖涓繃紼嬩腑錛屾垜浠湅鍒板鏋滀互鐢ㄦ埛宸ュ彿鍛藉悕鐨勫叏灞�涓存椂琛ㄤ笉瀛樺湪鏃惰繃紼嬩細(xì)鍘誨垱寤轟竴寮犲茍鎶?/span>out<span style="font-family: 瀹嬩綋">鍙傛暟緗負(fù)</span>0<span style="font-family: 瀹嬩綋">錛屽鏋滃凡緇忓瓨鍦ㄥ垯灝?/span>out<span style="font-family: 瀹嬩綋">鍙傛暟緗負(fù)</span>1<span style="font-family: 瀹嬩綋">銆?/span></p>
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span style="font-family: 瀹嬩綋">榪欐牱錛屾垜浠湪鎴戜滑鐨勫簲鐢ㄧ▼搴忎腑璋冪敤璇ヨ繃紼嬫椂錛屽鏋滃彇寰楃殑</span>out<span style="font-family: 瀹嬩綋">鍙傛暟涓?/span>1<span style="font-family: 瀹嬩綋">鏃訛紝鎴戜滑鍙互姣笉瀹㈡皵鍦拌煩鍑轟竴涓?/span>message<span style="font-family: 瀹嬩綋">鍛婅瘔鐢ㄦ埛璇?/span>&#8221;<span style="font-family: 瀹嬩綋">瀵逛笉璧鳳紝姝ゅ伐鍙鋒琚嬌鐢紒</span>&#8221;</p>
</div>
<img src ="http://www.aygfsteel.com/BeyondBoyxb/aggbug/147987.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.aygfsteel.com/BeyondBoyxb/" target="_blank">BeyondBoy</a> 2007-09-25 10:12 <a href="http://www.aygfsteel.com/BeyondBoyxb/archive/2007/09/25/147987.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item></channel></rss>                   <footer>
<div class="friendship-link">
<a href="http://www.aygfsteel.com/" title="&#29408;&#29408;&#20037;&#20037;&#20122;&#27954;&#27431;&#32654;&#19987;&#21306;&#95;&#20013;&#25991;&#23383;&#24149;&#20122;&#27954;&#32508;&#21512;&#20037;&#20037;&#50;&#48;&#50;&#95;&#22269;&#20135;&#31934;&#21697;&#20122;&#27954;&#31532;&#20116;&#21306;&#22312;&#32447;&#95;&#26085;&#26412;&#20813;&#36153;&#32593;&#31449;&#35270;&#39057;">&#29408;&#29408;&#20037;&#20037;&#20122;&#27954;&#27431;&#32654;&#19987;&#21306;&#95;&#20013;&#25991;&#23383;&#24149;&#20122;&#27954;&#32508;&#21512;&#20037;&#20037;&#50;&#48;&#50;&#95;&#22269;&#20135;&#31934;&#21697;&#20122;&#27954;&#31532;&#20116;&#21306;&#22312;&#32447;&#95;&#26085;&#26412;&#20813;&#36153;&#32593;&#31449;&#35270;&#39057;</a>

</div>

</footer>


主站蜘蛛池模板：
<a href="http://" target="_blank">共和县</a>|
<a href="http://" target="_blank">沐川县</a>|
<a href="http://" target="_blank">四子王旗</a>|
<a href="http://" target="_blank">永宁县</a>|
<a href="http://" target="_blank">江川县</a>|
<a href="http://" target="_blank">江阴市</a>|
<a href="http://" target="_blank">盐边县</a>|
<a href="http://" target="_blank">循化</a>|
<a href="http://" target="_blank">改则县</a>|
<a href="http://" target="_blank">海宁市</a>|
<a href="http://" target="_blank">泰顺县</a>|
<a href="http://" target="_blank">城口县</a>|
<a href="http://" target="_blank">邢台市</a>|
<a href="http://" target="_blank">阜新市</a>|
<a href="http://" target="_blank">湘潭市</a>|
<a href="http://" target="_blank">彝良县</a>|
<a href="http://" target="_blank">贡嘎县</a>|
<a href="http://" target="_blank">宁乡县</a>|
<a href="http://" target="_blank">大新县</a>|
<a href="http://" target="_blank">凤山县</a>|
<a href="http://" target="_blank">四会市</a>|
<a href="http://" target="_blank">泰宁县</a>|
<a href="http://" target="_blank">开鲁县</a>|
<a href="http://" target="_blank">和政县</a>|
<a href="http://" target="_blank">北流市</a>|
<a href="http://" target="_blank">横峰县</a>|
<a href="http://" target="_blank">满城县</a>|
<a href="http://" target="_blank">宾阳县</a>|
<a href="http://" target="_blank">嘉兴市</a>|
<a href="http://" target="_blank">平武县</a>|
<a href="http://" target="_blank">论坛</a>|
<a href="http://" target="_blank">封开县</a>|
<a href="http://" target="_blank">满城县</a>|
<a href="http://" target="_blank">凤台县</a>|
<a href="http://" target="_blank">南部县</a>|
<a href="http://" target="_blank">汉源县</a>|
<a href="http://" target="_blank">芒康县</a>|
<a href="http://" target="_blank">赤峰市</a>|
<a href="http://" target="_blank">金湖县</a>|
<a href="http://" target="_blank">三明市</a>|
<a href="http://" target="_blank">岳西县</a>|
<script>
(function(){
    var bp = document.createElement('script');
    var curProtocol = window.location.protocol.split(':')[0];
    if (curProtocol === 'https') {
        bp.src = 'https://zz.bdstatic.com/linksubmit/push.js';
    }
    else {
        bp.src = 'http://push.zhanzhang.baidu.com/push.js';
    }
    var s = document.getElementsByTagName("script")[0];
    s.parentNode.insertBefore(bp, s);
})();
</script>
</body>