锘??xml version="1.0" encoding="utf-8" standalone="yes"?>久久精品无码专区免费东京热,精品久久久久久国产,亚洲欧洲精品成人久久奇米网http://m.shnenglu.com/lilac/鍋?鎴愪負.鎷ユ湁.zh-cnTue, 01 Jul 2025 04:08:19 GMTTue, 01 Jul 2025 04:08:19 GMT60鍗佹潯鏈夌泭鐨勬秹涓栧繝鍛?/title><link>http://m.shnenglu.com/lilac/archive/2008/02/24/43170.html</link><dc:creator>鏉庝簹</dc:creator><author>鏉庝簹</author><pubDate>Sun, 24 Feb 2008 11:52:00 GMT</pubDate><guid>http://m.shnenglu.com/lilac/archive/2008/02/24/43170.html</guid><wfw:comment>http://m.shnenglu.com/lilac/comments/43170.html</wfw:comment><comments>http://m.shnenglu.com/lilac/archive/2008/02/24/43170.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://m.shnenglu.com/lilac/comments/commentRss/43170.html</wfw:commentRss><trackback:ping>http://m.shnenglu.com/lilac/services/trackbacks/43170.html</trackback:ping><description><![CDATA[<font size=2>濡備綍鍦ㄦ秹涓栦箣鍒濆皯璧板集璺紝鏈変竴涓ソ鐨勫紑绔紝寮濮嬩竴鐣垚鍔熺殑浜嬩笟錛熶互涓嬫槸涓浜涘厛琛岃呯Н绱殑10鏉℃湁鐩婄殑娑変笘蹇犲憡銆傚ソ濂藉湴閬靛驚銆佹妸鎻¤繖浜涘憡鍜屽緩璁惂錛屾瘮璧鋒墍瀛︾殑璇懼爞璇劇▼鏉ワ紝瀹冩涓嶉婅壊錛?nbsp;</font> <p><font size=2>    1. 涔頒釜闂歸挓錛屼互渚挎寜鏃跺彨閱掍綘銆?br>    璐潯鍜屼笉瀹堟椂錛岄兘灝嗘垚涓轟綘宸ヤ綔鍜屼簨涓氫笂鐨勭粖鑴氱煶錛屼換浣曟椂鍊欓兘涓鏍楓備笉浠呰瀛︿細鍑嗘椂錛屾洿瑕佸浼氭彁鍓嶃傚氨濡備綘鍧愯濺鍘繪煇鍦幫紝娌塊旂殑椋庢櫙寰堢編錛屼綘蹇嶄笉浣忎笅杞︾湅涓鐪嬶紝鍚庢潵铏界劧浣犺繕鏄刀鍒頒簡鏌愬湴錛屽嵈涓嶆槸鍑嗘椂鍒拌揪銆?#8220;闂歸挓”鍙槸涓縐嶇畝鍗曠殑鏍囧織鍜屾彁紺猴紝鐪熸鐏墊椿銆佸疄鐢ㄧ殑鏃墮棿錛屾帉鎻″湪姣忎釜浜虹殑蹇冧腑銆?br></font><br><font size=2>    2. 濡傛灉浣犱笉鍠滄鐜板湪鐨勫伐浣滐紝瑕佷箞杈炶亴涓嶅共錛岃涔堝氨闂槾涓嶈█銆?br></font><font size=2>    鍒濆嚭鑼呭簮錛屽線寰鐪奸珮鎵嬩綆錛屽績楂樻皵鍌詫紝澶т簨鍋氫笉浜嗭紝灝忎簨涓嶆効鍋氥備笉瑕佸吇鎴愭寫涓夋嫞鍥涚殑涔犳儻銆備笉瑕侀洦澶╃儲鎵撲紴錛屼笉甯︿紴鍙堟曟穻闆紝澶勫琛ㄧ幇鍑轟笉婊$殑鎯呯華銆傝浣忥紝涓嶅仛鍒欏凡錛岃鍋氬氨瑕佸仛濂姐?nbsp;<br></font><br><font size=2>    3. 姣忎釜浜洪兘鏈夊鐙殑鏃跺欍?br></font><font size=2>    瑕佸浼氬繊鍙楀鐙紝榪欐牱鎵嶄細鎴愮啛璧鋒潵銆傚勾杞諱漢鍢誨樆鍝堝搱銆佹墦鎵撻椆闂規儻浜嗭紝鍒頒簡涓涓檶鐢熺殑鐜錛岄潰瀵瑰艦褰㈣壊鑹茬殑浜哄拰浜嬶紝涓涓嬪瓙涓嶇煡鎵鎺搗鏉ワ紝鏈夋椂榪炰竴涓彲浠ュ懼績璇磋瘽鐨勫湴鏂逛篃娌℃湁銆傝繖鏃訛紝鍗冧竾鍒誕韜侊紝瀛︿細闈欏績錛屽浼氬繊鍙楀鐙傚湪瀛ょ嫭涓濊冿紝鍦ㄦ濊冧腑鎴愮啛錛屽湪鎴愮啛涓崌鍗庛備笉瑕佸洜涓哄瘋瀵炶屼貢浜嗘柟瀵革紝鑰屽幓鍋氭棤鑱婃棤鐩婄殑浜嬫儏錛岀櫧鐧芥氮璐逛簡瀹濊吹鐨勬椂闂淬?nbsp;<br></font><br><font size=2>    4. 璧拌繍鏃惰鍋氬ソ鍊掗湁鐨勫噯澶囥?nbsp;<br>    鏈変竴澶╋紝涓鍙嫄鐙歌蛋鍒頒竴涓憽钀勫洯澶栵紝鐪嬭閲岄潰姘寸伒鐏電殑钁¤悇鍨傛稁嬈叉淮銆傚彲鏄闈㈡湁鏍呮爮鎸$潃錛屾棤娉曡繘鍘匯備簬鏄畠涓鐙犲績緇濋涓夋棩錛屽噺鑲ヤ箣鍚庯紝緇堜簬閽昏繘钁¤悇鍥唴楗遍涓欏褲傚綋瀹冨績婊℃剰瓚沖湴鎯崇寮钁¤悇鍥椂錛屽彂瑙夎嚜宸卞悆寰楀お楗憋紝鎬庝箞涔熼捇涓嶅嚭鏍呮爮浜嗐傜浉淇′換浣曚漢閮戒笉鎰垮仛榪欐牱鐨勭嫄鐙搞傞璺悓鏍烽噸瑕併傞ケ甯﹀共綺紝鏅村甫闆ㄤ紴錛岀偣婊寸Н绱紝姘村埌娓犳垚銆傛湁鐨勪笢瑗夸粖澶╀技涔庝竴鏂囦笉鍊鹼紝浣嗘湁鏈濅竴鏃ヤ篃璁稿氨浼氳韓浠風櫨鍊嶃?br></font><br><font size=2>    5. 涓嶈鍍忕幓鐠冮偅鏍瘋剢寮便?br></font><font size=2>    鏈夌殑浜虹溂鐫涙葷洴鐫鑷繁錛屾墍浠ラ暱涓嶉珮鐪嬩笉榪滐紱鎬繪槸鍠滄鎬ㄥぉ灝や漢錛屼篃浣垮埆浜烘棤姣斿帉鐑︺傛病鏈夎嫤涓嫤錛屽摢鏉ョ敎涓敎錛熶笉瑕佸儚鐜葷拑閭f牱鑴嗗急錛岃屽簲鍍忔按鏅朵竴鏍烽忔槑錛屽お闃充竴鏍瘋緣鐓岋紝鑵婃涓鏍峰潥寮恒傛棦鐒剁潄寮鐪肩潧浜彈椋庣殑娓呭噳錛屽氨涓嶈鍩嬫ㄩ涓粏灝忕殑娌欑矑銆?nbsp;<br></font><br><font size=2>    6. 綆′綇鑷繁鐨勫槾宸淬?br></font><font size=2>    涓嶈璋堣鑷繁錛屾洿涓嶈璁鍒漢銆傝皥璁鴻嚜宸卞線寰浼氳嚜澶ц櫄浼紝鍦ㄥ悕涓嶅壇瀹炰腑澶卞幓鑷繁銆傝璁哄埆浜哄線寰闄峰叆楦℃瘺钂滅毊鐨勬槸闈炲彛鑸屼腑綰犵紶涓嶆竻銆傛瘡澶╀笅鐝悗鍜屼綘鐨勯偅浜涘悓浜嬫湅鍙嬪枬閰掕亰澶╁彲涓嶆槸浠跺ソ浜嬶紝鍥犱負錛岃繖涓棿寰寰浼氭妸璁鍚屼簨銆佹湅鍙嬪綋鍋氳瘽棰樸傝儗鍚庤璁轟漢鎬繪槸涓嶅ソ鐨勶紝灝ゅ叾鏄璁哄埆浜虹殑鐭錛岃繖浜涗細闄嶄綆浣犵殑浜烘牸銆?nbsp;</font></p> <p><font size=2>    7. 鏈轟細浠庝笉浼?#8220;澶辨帀”錛屼綘澶辨帀浜嗭紝鑷湁鍒漢浼氬緱鍒般?br></font><font size=2>    涓嶈鍑′簨鍦ㄥぉ錛屽畧鏍緟鍏旓紝鏇翠笉瑕佸瘎甯屾湜浜?#8220;鏈轟細”銆傛満浼氬彧涓嶈繃鏄浉瀵逛簬鍏呭垎鍑嗗鑰屽張鍠勪簬鍒涢犳満浼氱殑浜鴻岃█鐨勩備篃璁革紝浣犳涓哄け鍘諱竴涓満浼氳屾噴鎮斻佸煁鎬ㄧ殑鏃跺欙紝鏈轟細姝h浣犲闈㈤偅涓悓鏍風殑“鍊掗湁楝?#8221;緇欐姄浣忎簡銆傛病鏈夋満浼氾紝灝辮鍒涢犳満浼氾紝鏈変簡鏈轟細錛屽氨瑕佸閥濡欏湴鎶撲綇銆?nbsp;</font></p> <p><font size=2>    8. 鑻ョ數璇濊佹槸涓嶅搷錛屼綘璇ユ墦鍑哄幓銆?br></font><font size=2>    寰堝鏃跺欙紝鐢佃瘽浼氱粰浣犲甫鏉ユ剰鎯充笉鍒扮殑鏀惰幏錛屽畠涓嶆槸鑺辯摱錛屼粎浠呮垚涓轟竴縐嶆憜璁俱備氦浜嗘柊鏈嬪弸錛屽埆蹇樹簡鑰佹湅鍙嬶紝鏈嬪弸澶氫簡璺ソ璧般備氦闄呯殑涓澶ц瘈紿嶅氨鏄富鍔ㄣ傚ソ鐨勪漢緙樺ソ鐨勫彛紕戯紝寰寰鍔╀綘鐨勪簨涓氭洿涓婁竴涓彴闃躲?nbsp;</font></p> <p><font size=2>    9. 鍗冧竾涓嶈鍥犱負鑷繁宸茬粡鍒頒簡緇撳騫撮緞鑰岃崏鐜囩粨濠氥?br></font><font size=2>    鎯崇粨濠氾紝灝辮鎵句竴涓兘鍜屼綘蹇冨績鐩稿嵃銆佺浉杈呯浉鎼虹殑浼翠荊銆備笉瑕佸洜涓烘斁綰靛拰娓告垙鑰屾亱鐖憋紝涓嶈鍥犱負鎭嬬埍鑰屽獎鍝嶅伐浣滃拰浜嬩笟錛屾洿涓嶈鍥犱竴妗╄崏鐜囪屽け璐ョ殑濠氬Щ鑰屼嬌浜虹敓鍙楅樆銆傛劅鎯呯敤浜嬪線寰浼氬洜灝忓け澶с?nbsp;</font></p> <p><font size=2>    10. 鍐欏嚭浣犱竴鐢熻鍋氱殑浜嬫儏錛屾妸鍗曞瓙鏀懼湪鐨す閲岋紝緇忓父鎷垮嚭鏉ョ湅銆?br></font><font size=2>    浜虹敓瑕佹湁鐩爣錛岃鏈夎鍒掞紝瑕佹湁鎻愰啋錛岃鏈夌揣榪劅銆備竴涓張涓涓皬鐩爣涓茶搗鏉ワ紝灝辨垚浜嗕綘涓鐢熺殑澶х洰鏍囥傜敓媧誨瘜瓚充簡錛岀幆澧冩敼鍠勪簡錛屼笉瑕佸繕浜嗙毊澶歸噷閭e紶鐪嬩技钖勮杽鐨勫崟瀛愩?/font></p> <img src ="http://m.shnenglu.com/lilac/aggbug/43170.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://m.shnenglu.com/lilac/" target="_blank">鏉庝簹</a> 2008-02-24 19:52 <a href="http://m.shnenglu.com/lilac/archive/2008/02/24/43170.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>鏅氬紑鍙戜漢鍛樹笌杞歡宸ョ▼甯堢殑鍖哄埆[杞琞http://m.shnenglu.com/lilac/archive/2008/02/24/43169.html鏉庝簹鏉庝簹Sun, 24 Feb 2008 11:48:00 GMThttp://m.shnenglu.com/lilac/archive/2008/02/24/43169.htmlhttp://m.shnenglu.com/lilac/comments/43169.htmlhttp://m.shnenglu.com/lilac/archive/2008/02/24/43169.html#Feedback0http://m.shnenglu.com/lilac/comments/commentRss/43169.htmlhttp://m.shnenglu.com/lilac/services/trackbacks/43169.html瀵規瘮1錛?/font>

A銆佹櫘閫氬紑鍙戜漢鍛橈細
鎺屾彙浜嗚綆楁満鍩虹鐭ヨ瘑錛?br>鐔熸倝璁$畻鏈鴻祫婧愶紝瀛︿細浜嗙紪紼嬭璦錛屽枩嬈㈠崠寮勬妧宸э紝鍠滄姣旇緝緙栫▼璇█鐨勪紭鍔o紱
浠ヨ兘緙栧嚭鏌愮鐗規畩鍔熻兘鐨勭▼搴忎負鑽o紝涓嶆噦鍘熺悊錛屼笉姹傜敋瑙o紱
鍠滄涓漢寮鍙戯紝涓嶉噸瑙嗘枃妗g紪鍐欙紱

B銆佽蔣浠跺伐紼嬪笀錛?br>璁$畻鏈哄熀紜鐭ヨ瘑鎵庡疄錛?br>鎺屾彙涓ら棬浠ヤ笂緙栫▼璇█錛屽緢灝戝仠鐣欏湪琛ㄩ潰姣旇緝緙栫▼璇█鐨勪紭鍔o紱
浠ョ紪鍐欏嚭鐢ㄦ埛婊℃剰鐨勯珮璐ㄩ噺杞歡涓鴻崳銆?br>鎳傚緱涓漢寮鍙戝拰鍥㈤槦寮鍙戠殑鍒╁紛錛屾枃妗h鑼冿紝榻愬叏銆?/font>

瀵規瘮2錛?/font>

A銆佹櫘閫氬紑鍙戜漢鍛橈細
鍙噸瑙嗗姛鑳界殑瀹炵幇錛屼笉閲嶈繘搴﹀拰璐ㄩ噺鐨勬妸鎻°?br>鎬曡“綆?#8221;寰楀お姝伙紝鍔ㄤ笉鍔ㄥ氨璇撮檺鍒朵簡鎬濊礬錛屾病鏈夊彂鎸ョ┖闂淬?br>涓嶅枩嬈㈠仛嫻嬭瘯宸ヤ綔錛岃涓烘祴璇曚綆浜轟竴絳夛紝浠庢潵娌℃湁鍋氳繃嫻嬭瘯宸ヤ綔銆?br>鍙牴鎹嚜宸辯殑鐖卞ソ瀛︿範鎶鏈紱

B銆佽蔣浠跺伐紼嬪笀錛?br>鎳傚緱鍦ㄨ繘搴︺佽川閲忥紙鍔熻兘錛夊拰鎴愭湰涔嬮棿騫寵 銆?br>鎳傚緱瑙勮寖鐨勭洰鐨勫湪浜庨噸鐢紝閲嶇敤鏈夊埄浜庢彁楂樻晥鐜囧拰闆嗕腑綺懼姏鍒涙柊銆?br>璁や負嫻嬭瘯宸ヤ綔姣旂紪鐮佹洿鍏鋒寫鎴樻э紝鑷繁緇忓父涓哄悓浼寸殑浠g爜鍋氱櫧鐩掓祴璇曘?br>鏍規嵁浼佷笟欏圭洰鐨勯渶姹傚拰鑷繁鍙戝睍鐩爣鐨勫叡鍚岀偣閫夋嫨瀛︿範鍐呭鍜屾柟鍚戯紱

瀵規瘮3錛?/font>

A銆佹櫘閫氬紑鍙戜漢鍛橈細
璁や負鍒漢紼嬪簭寰堝樊錛屼笉鍠滄鐪嬪埆浜虹殑浠g爜錛?br>鎬昏涓鴻嚜宸辨瘮涓氬姟涓撳榪樻洿鐞嗚В闇姹傘?br>欏圭洰寮濮嬫椂錛屽枩嬈㈣:“娌¢棶棰橈紝SO EASY”銆?br>欏圭洰澶уぇ寤舵湡鏃訛紝鍠滄璇達細“璁捐澶儌錛屾病娉曠紪紼?#8221;銆?/font>

B銆佽蔣浠跺伐紼嬪笀錛?br>鍠滄涓哄悓浜嬭蛋鏌ヤ唬鐮侊紝騫朵互姝よ幏寰楀涔犱粬浜轟紭鐐圭殑鏈轟細錛?br>鎳傚緱鑷繁鍙槸鍙兘姣斾笟鍔′笓瀹舵洿鎳傜紪紼嬨?br>欏圭洰寮濮嬫椂錛屽枩嬈㈤棶:“閭f槸浠涔堬紵榪欐槸涓轟粈涔堬紵”銆?br>欏圭洰澶уぇ寤舵湡鏃訛紝鍠滄璇達細“鎴戜負浠涔堝氨娌℃兂鍒?#8230;”銆?/font>



鏉庝簹 2008-02-24 19:48 鍙戣〃璇勮
]]>
鐪熺殑鐢蜂漢[杞琞http://m.shnenglu.com/lilac/archive/2008/02/24/43168.html鏉庝簹鏉庝簹Sun, 24 Feb 2008 11:35:00 GMThttp://m.shnenglu.com/lilac/archive/2008/02/24/43168.htmlhttp://m.shnenglu.com/lilac/comments/43168.htmlhttp://m.shnenglu.com/lilac/archive/2008/02/24/43168.html#Feedback0http://m.shnenglu.com/lilac/comments/commentRss/43168.htmlhttp://m.shnenglu.com/lilac/services/trackbacks/43168.html
銆銆寰韞堢煩錛岃佸疄鏈垎錛屾湭蹇呮槸鐪熸鐨勭敺浜恒傝。鍐犳妤氾紝閬撹矊宀哥劧錛屼篃涓嶄竴瀹氭槸鐪熸鐨勭敺浜恒傛瘡澶╂櫄涓婁笅鐝悗灝卞噯鏃跺洖瀹訛紝鍘畧鐫鑰佸﹩瀛╁瓙鐑倳澶寸殑鏄ソ鐢蜂漢錛屼絾鑲畾涓嶆槸鐪熸鐨勭敺浜恒傞氬杈炬棪楗厭鍋氫箰錛屽鑺辯湢鏌崇殑錛屼篃涓嶆槸鐪熸鐨勭敺浜恒備竴鎺峰崈閲戠殑瀵岃豹鏈繀鏄湡姝g殑鐢蜂漢錛屽崈閲戞暎灝斤紝瀵岃豹涔熶細鑼曡寱瀛戠珛錛屽艦褰辯浉鍚娿傚彵璇ч浜戠殑鏀挎不瀹舵湭蹇呮槸鐪熸鐨勭敺浜猴紝褰撴潈鍔涘け鍘葷殑鏃跺欙紝鏀挎不瀹朵篃浼氭撥钀戒負钀介瓌鐨勯厭寰掋傛弧鍙g殑姹¤█縐借涓嶆槸鐪熸鐨勭敺浜猴紝铏界劧鐪熸鐨勭敺浜轟篃瑕侀獋濞橈紝鍋跺皵涔熶細鎶婁粬濡堢殑鎸傚湪鍢翠笂銆傛補澶寸矇闈㈢殑灝忕敓鏇翠笉鏄湡姝g殑鐢蜂漢錛屾弧鍙g殑濞樺鑵旈櫎浜嗘壄鎹忎綔鎬佷究鏄護浜轟綔鍛曘傝秼鐐庨檮鍔匡紝榪芥嘗閫愭祦鐨勬槸鍔垮埄灝忎漢錛涙姇鏈哄彇宸э紝鎼紕鏄潪鐨勬槸鏃犺誨ジ浜恒?

銆銆鐪熸鐨勭敺浜烘暍鐖辨暍鎭紝鏁㈡掓暍璦錛屾暍璇存暍鍋氾紝鏁㈠仛鏁㈠綋銆傜湡姝g殑鐢蜂漢鍙互涓鏃犳墍鏈変絾鍗存嫢鏈夊ぉ涓嬶紝鐪熸鐨勭敺浜轟篃浼氬熼厭嫻囨剚浣嗗嵈涓嶄細涓韞朵笉鎸傜湡姝g殑鐢蜂漢璞埥鍧﹁崱浣嗗茍涓嶇己涔忚皨鐣ワ紝鐪熸鐨勭敺浜哄彲浠ヨ縐樿屼笉楝肩銆傜湡姝g殑鐢蜂漢鏈繀鏄垚鍔熺殑鐢蜂漢錛屼絾鐪熸鐨勭敺浜哄嵆浣挎槸澶辮觸浜嗕篃緇濅笉姘旈銆傜湡姝g殑鐢蜂漢鐙傛斁鑰屼笉鍌叉參錛岀湡姝g殑鐢蜂漢璋﹂婅屼笉鑷崙銆傜湡姝g殑鐢蜂漢鏋滄柇鍒氭瘏錛岀湡姝g殑鐢蜂漢鐧炬姌涓嶆尃銆?

銆銆鐪熸鐨勭敺浜烘暍浜庢壙璁よ嚜宸辯殑閿欒騫舵壙鎷呰嚜宸辯殑璐d換錛岀湡姝g殑鐢蜂漢鏁簬闈㈠鐜板疄鑰岀粷涓嶄負鑷繁瀵繪壘寮鑴辯殑鐞嗙敱銆傜湡姝g殑鐢蜂漢鏈夎鏈夎倝鏈変赴瀵岀殑鎯呮劅錛岀湡姝g殑鐢蜂漢鍚屾牱鏈夎崱姘斿洖鑲犵殑鐖辨儏銆傜湡姝g殑鐢蜂漢鐖辨睙灞憋紝涔熺埍緹庝漢銆傜湡姝g殑鐢蜂漢閾侀鏌旇偁錛屾滈鎯滅帀錛屼絾鐪熸鐨勭敺浜虹粷瀵逛笉浼氫負鍎垮コ涔嬫儏鑰屾斁寮冧竴甯﹀北娌熾傜涓嶅紑濂充漢鐨勭敺浜猴紝涓嶆槸鐪熸鐨勭敺浜恒傝濂充漢鎶涘純鐨勭敺浜猴紝涔熶笉鏄湡姝g殑鐢蜂漢銆傜湡姝g殑鐢蜂漢鎳傚緱濡備綍嬈h祻濂充漢錛屽姩鎯呰屼笉婊ユ儏錛岃倝嬈茶屼笉鍏芥銆傜湡姝g殑鐢蜂漢鐖遍厭鐖辮姳錛岀埍楂樺北嫻佹按錛屽洜涓虹湡姝g殑鐢蜂漢鏇存噦寰楁璧忎竴騫呯編涓界殑椋庢櫙錛屼竴棣栧姩浜虹殑灝忚瘲錛屽拰涓鏇叉偁鎵殑姝屻傛墍浠ョ湡姝g殑鐢蜂漢媧葷潃渚挎椿寰楀潶鍧﹁崱鑽★紝姝諱究姝葷殑鎱鋒叏嬋鏄傘?

銆銆鐪熸鐨勭敺浜鴻嫃涓栫嫭绔嬶紝妯屼笉嫻併傛湁鐨勬椂鍊欙紝濂界敺浜烘湭蹇呮槸鐪熸鐨勭敺浜猴紝澧ㄥ畧鎴愯錛屼紭鏌斿鏂紝鍙兘鏄竴浜嬫棤鎴愮殑搴鎬漢銆傜湡姝g殑鐢蜂漢鏈夋椂鐢氳嚦鍙兘鏄崄鎭朵笉璧︾殑鍧忎漢錛屽甯岀壒鍕掑棞琛鎴愭ф互鏉鏃犺緶錛屼絾鏃犲彲鍚﹁浠栧亸鎵х媯鐑殑涓漢欖呭姏鍜岄琚栨墠鑳戒嬌浠栨垚涓哄拰鍑拻錛屾嬁鐮翠粦錛岀敋鑷沖拰鏂ぇ鏋楋紝鎴撮珮涔愪竴鏍風殑鐪熸鐨勭敺浜轟腑鐨勬瀬鍝併傜湡姝g殑鐢蜂漢鏄話澶╁ぇ絎戠殑鏉庣櫧錛屾暍鍦ㄥぉ瀛愰潰鍓嶈嚜縐伴厭浠欐梺鑻ユ棤浜猴紱鐪熸鐨勭敺浜烘槸浠板ぉ闀垮暩澹嬋鐑堢殑宀抽錛屽嵆渚垮湪鑻遍泟鏈礬涔熷.鎬鐫閲嶆暣灞辨渤鐨勬ⅵ鎯熾傜湡姝g殑鐢蜂漢鏄槗姘存渤杈瑰ぇ椋庤惂钀т腑鐨勫.澹紝鎱鋒叏鎮叉瓕涓璺豹榪堣笍涓婁笉褰掔殑寰佺▼銆?

銆銆鐪熸鐨勭敺浜哄彲浠ュ繊杈卞惈鍨絾鍐充笉鑻熶笖鍋風敓錛屽閽╄返鍗ц柂灝濊儐錛屽闊╀俊鑶濆眻鑳笅銆傚洜涓轟粬鐭ラ亾錛屼竴涓湡姝g殑鐢蜂漢錛屽簲璇ユ嫢鏈夋瘮澶ф搗鏇翠負騫塊様錛屾瘮钃濆ぉ鏇翠負楂樿繙鐨勮兏鎬銆?

銆銆鐪熸鐨勭敺浜猴紝鍗充嬌钀介瓌娼﹀掞紝浠栦篃涓嶄細澶卞幓璞佽揪涔愯鐨勪漢鐢熺悊鎯熾備粬鍙互榛橀粯鏃犻椈錛屼絾浠栦笉鑳界紕屾棤涓恒傜湡姝g殑鐢蜂漢錛屽嵆浣夸粬嫻佽惤琛楀ご錛屾氮榪瑰ぉ娑紝涔熸案榪滃潥瀹堢潃蹇冪伒娣卞鐨勪竴鍧楀噣鍦熴?

銆銆鐪熸鐨勭敺浜哄偛楠ㄩ摦閾紝鐪熸鐨勭敺浜烘旦姘旈暱瀛樸?/div>

鏉庝簹 2008-02-24 19:35 鍙戣〃璇勮
]]>渚冧緝"鑹崇収闂?http://m.shnenglu.com/lilac/archive/2008/02/18/42903.html鏉庝簹鏉庝簹Mon, 18 Feb 2008 11:12:00 GMThttp://m.shnenglu.com/lilac/archive/2008/02/18/42903.htmlhttp://m.shnenglu.com/lilac/comments/42903.htmlhttp://m.shnenglu.com/lilac/archive/2008/02/18/42903.html#Feedback0http://m.shnenglu.com/lilac/comments/commentRss/42903.htmlhttp://m.shnenglu.com/lilac/services/trackbacks/42903.html閮芥嚨浜嗭紝澶у閮芥嚨浜嗐傘傘傚紑濮嬬殑鏃跺欑湡鐨勫笇鏈涳紝涓鍒囬兘鏄倰浣溿傘傘?
鍙槸涓鍙?#8220;鎴戝緢鍌?#8221;錛屼粈涔堥兘璇存槑闂浜嗭紝鍏跺疄榪欎簺閮芥槸涓漢鐨勯殣縐佷簨鎯咃紝鏀懼埌緗戠粶涓婃槸榪囧垎浜嗐傚彲鏄綔涓哄叕浼椾漢鐗╋紝浠栦滑鐨勫獎鍝嶅姏澶ぇ浜嗭紝澶у埌鎴戜滑涓嶆兂鐪嬩篃浼氬嚭鐜板湪鎴戜滑鐨勭溂鍓嶃?
鐪嬩簡閭d箞澶氱殑璇勮錛?#8220;鍙楀浜?#8221;涓煇涓浣嶄綔涓轟竴涓ぇ瀹墮兘瑙夊緱寰堝崟綰殑寰堝崟綰殑鍏紬浜虹墿錛屼釜浜虹敓媧葷‘鏄繖鏍風殑涔變竷鍏碂錛岃鎴戣寰楁伓蹇冿紒寰堝浜鴻榪欎釜鍙楀浜猴紝閭d釜鍙楀浜猴紒鍏跺疄鍙楀鏈澶х殑鏄偅浜涙墍璋撶殑fans浠紝浠栦滑鐨勫績鐩腑鐨勫伓鍍忔槸榪欎釜鏍峰瓙錛屼粬浠殑蹇冮噷涔熼毦浠ユ帴鍙楋紒涓嶆槸璇翠綘涓嶈兘鍋氫粈涔堜粈涔堜簨鎯咃紝鍙槸鍙伴潰涓婅鐨勫お鍗曠函錛屽彴涓嬨傘傘傛湁涓縐嶈嬈洪獥鐨勬劅瑙夛紒錛?
"涓嶆曚綘鎬庝箞鐫...灝辨曚綘瑁?.."
鍏ㄥ浗浜烘皯閮藉湪瀛︿範璁茶瘹淇?鍙繖浜涘叕浼椾漢鐗╁拷鎮犲ぇ浼楅偅涔堝騫?..
鎺寮鐨勮嚟璞嗚厫閮介偅涔堣嚟浜?..娌℃巰寮鐨勫憿...
涓嶆暍鎯?..
鍛靛懙!涔熶笉闇瑕佹兂!!鍙細鏇磋嚟!!

鏉庝簹 2008-02-18 19:12 鍙戣〃璇勮
]]>
瀹堜警鎴戠殑鏄ュぉhttp://m.shnenglu.com/lilac/archive/2008/02/03/42488.html鏉庝簹鏉庝簹Sun, 03 Feb 2008 13:41:00 GMThttp://m.shnenglu.com/lilac/archive/2008/02/03/42488.htmlhttp://m.shnenglu.com/lilac/comments/42488.htmlhttp://m.shnenglu.com/lilac/archive/2008/02/03/42488.html#Feedback0http://m.shnenglu.com/lilac/comments/commentRss/42488.htmlhttp://m.shnenglu.com/lilac/services/trackbacks/42488.html鏄庡ぉ灝辮鏀舵嬀鑷繁鐨勮儗鍖?

鍥炲埌宸茬粡涓騫存病鏈夊洖榪囩殑鑰佸浜?

紿佺劧鏈変竴鐐圭偣瀹蟲曞洖瀹剁殑鎰熻,

鍏跺疄涔熻洰鎯沖鐨?

鎯崇埜鐖稿濡?榪樻湁灝忓,

鍛靛懙!涓嶇煡閬撲負浠涔?灝辨槸鏈変竴鐐圭偣鐨勫鎬?

鐜板湪鍦ㄨ竟鍚潃鐜嬪己鐨?縐嬪ぉ涓嶅洖鏉?/strong>"

杈瑰啓鐫榪欑瘒鏃ュ織!

甯屾湜鏄ヨ妭榪囨潵涔嬪悗,

鎴戠殑鏄ュぉ鍙互鍒版潵!

鎴戝凡緇忚繃浜嗚涔呯殑鍐ぉ浜?

08騫寸殑鏄ヨ妭涔熸槸鎴戠粰鑷繁鐨勪竴涓害瀹?

榪欐椂鏈鍚庣殑涓涓湡闄?

鏄敼鍙樻垜鑷繁鐨勬渶鍚庢湡闄?

^_^ 鐜板湪鏈変竴縐嶆劅瑙?/p>

"鑷繁鐭ラ亾鑷繁鏈変簺鎯寵鐨勮瘽,鍗翠笉鐭ラ亾鎬庝箞鍐欏嚭鏉?鎬庝箞鍘昏〃杈?涔熻鏇村鐨勬槸鑷繁涓嶆兂琛ㄨ揪!"

甯屾湜鏄ヨ妭鍓嶇殑鍐ぉ鎶婃垜鐨勪竴鍒囩儲鎭煎拰涓嶆剦蹇殑浜嬫儏閮藉甫璧?

鐒跺悗闈欓潤鐫瀹堜警鎴戠殑鏄ュぉ!



鏉庝簹 2008-02-03 21:41 鍙戣〃璇勮
]]>
綺懼鐨凷QL鍜孲QL SERVER 涓嶢CCESS銆丒XCEL鐨勬暟鎹鍏ュ鍑鴻漿鎹?/title><link>http://m.shnenglu.com/lilac/archive/2008/01/13/41075.html</link><dc:creator>鏉庝簹</dc:creator><author>鏉庝簹</author><pubDate>Sat, 12 Jan 2008 16:21:00 GMT</pubDate><guid>http://m.shnenglu.com/lilac/archive/2008/01/13/41075.html</guid><wfw:comment>http://m.shnenglu.com/lilac/comments/41075.html</wfw:comment><comments>http://m.shnenglu.com/lilac/archive/2008/01/13/41075.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://m.shnenglu.com/lilac/comments/commentRss/41075.html</wfw:commentRss><trackback:ping>http://m.shnenglu.com/lilac/services/trackbacks/41075.html</trackback:ping><description><![CDATA[     鎽樿:  璇存槑錛氬鍒惰〃(鍙鍒剁粨鏋?婧愯〃鍚嶏細a 鏂拌〃鍚嶏細b)      select * into b from a where 1<>1    * 璇存槑錛氭嫹璐濊〃(鎷瘋礉鏁版嵁,婧愯〃鍚嶏細a ...  <a href='http://m.shnenglu.com/lilac/archive/2008/01/13/41075.html'>闃呰鍏ㄦ枃</a><img src ="http://m.shnenglu.com/lilac/aggbug/41075.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://m.shnenglu.com/lilac/" target="_blank">鏉庝簹</a> 2008-01-13 00:21 <a href="http://m.shnenglu.com/lilac/archive/2008/01/13/41075.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>澶囦喚鏈嶅姟鍣ㄧSQL SERVER鏁版嵁搴撹嚦鏈湴鐩綍http://m.shnenglu.com/lilac/archive/2008/01/13/41074.html鏉庝簹鏉庝簹Sat, 12 Jan 2008 16:18:00 GMThttp://m.shnenglu.com/lilac/archive/2008/01/13/41074.htmlhttp://m.shnenglu.com/lilac/comments/41074.htmlhttp://m.shnenglu.com/lilac/archive/2008/01/13/41074.html#Feedback0http://m.shnenglu.com/lilac/comments/commentRss/41074.htmlhttp://m.shnenglu.com/lilac/services/trackbacks/41074.html/**//*鏁告摎搴倷浠藉瓨鍎查亷紼?/span>*/
/**//*鏀寔寰炴湇鍕欏櫒鍌欎喚鏁告摎鑷蟲湰鍦版鍣ㄤ笂*/
-- 
CREATE PROCEDURE up_dbbackup
(
@backup_db_name VARCHAR(128),
@filename VARCHAR(128), /**//*鍌欎喚璺緫+鏂囦歡鍚?/span>*/
@flag VARCHAR(60) OUTPUT
)
AS
SET NOCOUNT ON
DECLARE @sql NVARCHAR(4000),@par NVARCHAR(1000)
IF NOT EXISTS(
  
SELECT * FROM master..sysdatabases
    
WHERE name=@backup_db_name
    )
BEGIN
  
SELECT @flag='鏁告摎搴?/span>'+@backup_db_name+'涓嶅瓨鍦?'
  
RETURN
END
ELSE
BEGIN
  
IF RIGHT(@filename,1)<>'\' AND CHARINDEX('\',@filename)<>0
  
BEGIN
  
/**//*瀹氱京妯欒獙*/
 
  
DECLARE @lFlag INT
  
EXECUTE @lFlag=master..xp_cmdshell 'DIR Z:'
  
IF @lFlag<>0
  
BEGIN
    
/**//* 鍦ㄥ鎴舵192.168.2.45涓婂緩绔嬩竴鍊嬪畬鍏ㄥ叡浜洰閷刣b,鎸囧畾涓鍊嬬敤鎴跺悕鍜屽瘑紕?Win98鐢ㄦ埗涓嶉渶瑕佺敤鎴跺悕鍜屽瘑紕?/span>*/
    
EXECUTE @lFlag=master..xp_cmdshell 'NET USE Z: \\192.168.2.45\db$ test /user:ca.atc\test'
    
IF @lFlag<>0
    
BEGIN  
      
SELECT @flag='鏈嶅嫏鍣ㄥ壍寤虹洰閷勫け鏁?'
      
RETURN
    
END
  
END 
  
SELECT @par='@filename VARCHAR(1000)'
  
SELECT @sql='BACKUP DATABASE '+@backup_db_name+' TO DISK=@filename WITH INIT'
  
EXECUTE sp_executesql @sql,@par,@filename
  
EXECUTE master..xp_cmdshell 'NET USE Z: /DELETE'
  
SELECT @flag='鏁告摎搴?/span>'+@backup_db_name+'鍌欎喚鎴愬姛!'
  
RETURN
END
ELSE
BEGIN
    
SELECT @flag='鏁告摎搴倷浠借礬寰戦尟瑾?'
    
RETURN
END
END


**浠ヤ笂閬庣▼鍦⊿QL SERVER涓嬫脯瑭﹂氶亷

鏉庝簹 2008-01-13 00:18 鍙戣〃璇勮
]]>
sql瀹炵幇鍒嗘鍔熻兘鐨勫嚱鏁?鍘繪帀閲嶅璁板綍錛岃幏鍙栭噸澶嶈褰?/title><link>http://m.shnenglu.com/lilac/archive/2008/01/13/41073.html</link><dc:creator>鏉庝簹</dc:creator><author>鏉庝簹</author><pubDate>Sat, 12 Jan 2008 16:12:00 GMT</pubDate><guid>http://m.shnenglu.com/lilac/archive/2008/01/13/41073.html</guid><wfw:comment>http://m.shnenglu.com/lilac/comments/41073.html</wfw:comment><comments>http://m.shnenglu.com/lilac/archive/2008/01/13/41073.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://m.shnenglu.com/lilac/comments/commentRss/41073.html</wfw:commentRss><trackback:ping>http://m.shnenglu.com/lilac/services/trackbacks/41073.html</trackback:ping><description><![CDATA[<div id="gcocggy" class="g_t_left c07 content" id=blogtext__fks_2s8dCJjn9zxDj4SGMMC67if8UXwyjvxx> <div >sql瀹炵幇鍒嗘鍔熻兘鐨勫嚱鏁?/a> </div> <div> <p><font face=Arial><font face=Arial>--綆鍗曞垎孌佃鍙?/font></font></p> <div style="BORDER-RIGHT: #cccccc 1px dashed; BORDER-TOP: #cccccc 1px dashed; BORDER-LEFT: #cccccc 1px dashed; BORDER-BOTTOM: #cccccc 1px dashed; BACKGROUND-COLOR: #f1f1f1"> <pre style="WIDTH: 565px; WORD-WRAP: break-word"> <span style="COLOR: #0000ff">declare</span> @b <span style="COLOR: #0000ff">varchar</span>(20) <span style="COLOR: #0000ff">select</span> @b=<span style="COLOR: #ff0000">'a-b-c-d-e'</span> <span style="COLOR: #008080">--澶勭悊 </span><span style="COLOR: #0000ff">declare</span> @sql <span style="COLOR: #0000ff">varchar</span>(4000) <span style="COLOR: #0000ff">select</span> @sql= <span style="COLOR: #ff0000">'<span style="COLOR: #0000ff">select</span> '</span><span style="COLOR: #ff0000">''</span>+<span style="COLOR: #ff00ff">replace</span>(@b,<span style="COLOR: #ff0000">'-'</span>,<span style="COLOR: #ff0000">''</span><span style="COLOR: #ff0000">' union all <span style="COLOR: #0000ff">select</span> '</span><span style="COLOR: #ff0000">''</span>) <span style="COLOR: #ff0000">''</span><span style="COLOR: #ff0000">''</span> <span style="COLOR: #0000ff">exec</span>(@sql)</pre> </div> <font face=Arial>--瀹炵幇 split 鍒嗘鍔熻兘鐨勫嚱鏁?/font><br> <div style="BORDER-RIGHT: #cccccc 1px dashed; BORDER-TOP: #cccccc 1px dashed; BORDER-LEFT: #cccccc 1px dashed; BORDER-BOTTOM: #cccccc 1px dashed; BACKGROUND-COLOR: #f1f1f1"> <pre style="WIDTH: 565px; WORD-WRAP: break-word"> <span style="COLOR: #0000ff">create</span> <span style="COLOR: #0000ff">function</span> f_split(@SourceSql <span style="COLOR: #0000ff">varchar</span>(8000),@StrSeprate <span style="COLOR: #0000ff">varchar</span>(10)) <span style="COLOR: #0000ff">returns</span> @temp <span style="COLOR: #0000ff">table</span>(a <span style="COLOR: #0000ff">varchar</span>(100)) <span style="COLOR: #0000ff">as</span> <span style="COLOR: #0000ff">begin</span> <span style="COLOR: #0000ff">declare</span> @i <span style="COLOR: #0000ff">int</span> <span style="COLOR: #0000ff">set</span> @SourceSql=<span style="COLOR: #ff00ff">rtrim</span>(<span style="COLOR: #ff00ff">ltrim</span>(@SourceSql)) <span style="COLOR: #0000ff">set</span> @i=<span style="COLOR: #ff00ff">charindex</span>(@StrSeprate,@SourceSql) <span style="COLOR: #0000ff">while</span> @i>=1 <span style="COLOR: #0000ff">begin</span> <span style="COLOR: #0000ff">insert</span> @temp <span style="COLOR: #0000ff">values</span>(<span style="COLOR: #ff00ff">left</span>(@SourceSql,@i-1)) <span style="COLOR: #0000ff">set</span> @SourceSql=<span style="COLOR: #ff00ff">substring</span>(@SourceSql,@i+1,<span style="COLOR: #ff00ff">len</span>(@SourceSql)-@i) <span style="COLOR: #0000ff">set</span> @i=<span style="COLOR: #ff00ff">charindex</span>(@StrSeprate,@SourceSql) <span style="COLOR: #0000ff">end</span> <span style="COLOR: #0000ff">if</span> @SourceSql<><span style="COLOR: #ff0000">'\'</span> <span style="COLOR: #0000ff">insert</span> @temp <span style="COLOR: #0000ff">values</span>(@SourceSql) <span style="COLOR: #0000ff">return</span> <span style="COLOR: #0000ff">end</span> <span style="COLOR: #008080">--鐢ㄦ硶: </span><span style="COLOR: #0000ff">select</span> * <span style="COLOR: #0000ff">from</span> dbo.f_split(<span style="COLOR: #ff0000">'A:B:C:D:E'</span>,<span style="COLOR: #ff0000">':'</span>) <span style="COLOR: #008080">--杈撳嚭 </span> a 1 A 2 B 3 C 4 D 5 E</pre> </div> <font face=Arial>--瀹炵幇綆鍗曟ā緋婃煡鎵劇殑榪囩▼</font> <div style="BORDER-RIGHT: #cccccc 1px dashed; BORDER-TOP: #cccccc 1px dashed; BORDER-LEFT: #cccccc 1px dashed; BORDER-BOTTOM: #cccccc 1px dashed; BACKGROUND-COLOR: #f1f1f1"> <pre style="WIDTH: 565px; WORD-WRAP: break-word"> <span style="COLOR: #0000ff">create</span> procedure splitter @<span style="COLOR: #ff00ff">str</span> <span style="COLOR: #0000ff">varchar</span>(1024) <span style="COLOR: #0000ff">as</span> <span style="COLOR: #0000ff">declare</span> @s <span style="COLOR: #0000ff">varchar</span>(1024) <span style="COLOR: #0000ff">declare</span> @i <span style="COLOR: #0000ff">int</span> <span style="COLOR: #0000ff">set</span> @s=<span style="COLOR: #ff0000">'<span style="COLOR: #0000ff">select</span> message <span style="COLOR: #0000ff">from</span> T_QQMsgLog <span style="COLOR: #0000ff">where</span> 1=1'</span> <span style="COLOR: #0000ff">set</span> @i=1 </pre> </div>  -------------------------------------------------------------------------------------- <div >鍘繪帀閲嶅璁板綍錛岃幏鍙栭噸澶嶈褰?/a> </div> <div style="COLOR: #008080">--鏌ヨ涓涓〃涓湁鏁堝幓鎺夐噸澶嶇殑璁板綍錛孶serID涓鴻嚜澧為暱涓婚敭錛孯oleID涓洪噸澶嶅瓧孌?br></span><span style="COLOR: #0000ff">select</span> MIN(UserID) <span style="COLOR: #0000ff">as</span> UserID, RoleID <span style="COLOR: #0000ff">from</span> tmpTable <span style="COLOR: #0000ff">group</span> <span style="COLOR: #0000ff">by</span> RoleID<br><br><span style="COLOR: #0000ff">select</span> RoleID <span style="COLOR: #0000ff">from</span> tmpTable <span style="COLOR: #0000ff">group</span> <span style="COLOR: #0000ff">by</span> RoleID HAVING (<span style="COLOR: #ff00ff">count</span>(*) > 1)<br><br><span style="COLOR: #0000ff">select</span> <span style="COLOR: #0000ff">distinct</span> * <span style="COLOR: #0000ff">from</span> tmpTable<br><br><br><span style="COLOR: #008080">--鍒犻櫎閲嶅璁板綍<br></span><span style="COLOR: #0000ff">select</span> <span style="COLOR: #0000ff">distinct</span> * <span style="COLOR: #0000ff">into</span> #Tmp <span style="COLOR: #0000ff">from</span> tableName <br><span style="COLOR: #0000ff">drop</span> <span style="COLOR: #0000ff">table</span> tableName <br><span style="COLOR: #0000ff">select</span> * <span style="COLOR: #0000ff">into</span> tableName <span style="COLOR: #0000ff">from</span> #Tmp <br><span style="COLOR: #0000ff">drop</span> <span style="COLOR: #0000ff">table</span> #Tmp</div> </div> </div> <img src ="http://m.shnenglu.com/lilac/aggbug/41073.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://m.shnenglu.com/lilac/" target="_blank">鏉庝簹</a> 2008-01-13 00:12 <a href="http://m.shnenglu.com/lilac/archive/2008/01/13/41073.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>綆鍗曞瘑鐮佸姞瀵嗚繃紼?/title><link>http://m.shnenglu.com/lilac/archive/2008/01/13/41071.html</link><dc:creator>鏉庝簹</dc:creator><author>鏉庝簹</author><pubDate>Sat, 12 Jan 2008 16:11:00 GMT</pubDate><guid>http://m.shnenglu.com/lilac/archive/2008/01/13/41071.html</guid><wfw:comment>http://m.shnenglu.com/lilac/comments/41071.html</wfw:comment><comments>http://m.shnenglu.com/lilac/archive/2008/01/13/41071.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://m.shnenglu.com/lilac/comments/commentRss/41071.html</wfw:commentRss><trackback:ping>http://m.shnenglu.com/lilac/services/trackbacks/41071.html</trackback:ping><description><![CDATA[<div style="COLOR: #008080">--鏂板鎴栦慨鏀瑰瘑鐮?br></span><span style="COLOR: #0000ff">create</span> <span style="COLOR: #0000ff">proc</span> modifypwd<br>@uid <span style="COLOR: #0000ff">varchar</span>(16),@pwd <span style="COLOR: #0000ff">varchar</span>(16)<br><span style="COLOR: #0000ff">as</span><br><span style="COLOR: #0000ff">declare</span> @encode <span style="COLOR: #0000ff">varbinary</span>(255)<br><span style="COLOR: #0000ff">set</span> @encode=<span style="COLOR: #ff00ff">convert</span>(<span style="COLOR: #0000ff">varbinary</span>(255),pwdencrypt(@pwd))<br><span style="COLOR: #0000ff">if</span> <span style="COLOR: #808080">exists</span>(<span style="COLOR: #0000ff">select</span> uid <span style="COLOR: #0000ff">from</span> [<span style="COLOR: #ff00ff">user</span>] <span style="COLOR: #0000ff">where</span> uid=@uid)<br><span style="COLOR: #0000ff">update</span> [<span style="COLOR: #ff00ff">user</span>] <span style="COLOR: #0000ff">set</span> pwd=@encode <span style="COLOR: #0000ff">where</span> uid=@uid<br><span style="COLOR: #0000ff">else</span><br><span style="COLOR: #0000ff">insert</span> <span style="COLOR: #0000ff">into</span> [<span style="COLOR: #ff00ff">user</span>](uid,pwd) <span style="COLOR: #0000ff">values</span>(@uid,@encode)<br>go<br><br><span style="COLOR: #008080">--鍒ゆ柇瀵嗙爜鏄惁姝g‘<br></span><span style="COLOR: #0000ff">create</span> <span style="COLOR: #0000ff">proc</span> checkid<br>@uid <span style="COLOR: #0000ff">varchar</span>(16),@pwd <span style="COLOR: #0000ff">varchar</span>(16)<br><span style="COLOR: #0000ff">as</span><br><span style="COLOR: #0000ff">declare</span> @encode <span style="COLOR: #0000ff">varbinary</span>(255)<br><span style="COLOR: #0000ff">select</span> @encode=pwd <span style="COLOR: #0000ff">from</span> [<span style="COLOR: #ff00ff">user</span>] <span style="COLOR: #0000ff">where</span> uid=@uid<br><span style="COLOR: #0000ff">if</span> pwdcompare(@pwd,@encode,0)=<span style="COLOR: #ff0000">'1'</span><br><span style="COLOR: #0000ff">select</span> <span style="COLOR: #ff0000">'鐧誨綍鎴愬姛'</span><br><span style="COLOR: #0000ff">else</span><br><span style="COLOR: #0000ff">select</span> <span style="COLOR: #ff0000">'鐢ㄦ埛鍚嶆垨瀵嗙爜閿?</span><br>GO<br><br><span style="COLOR: #008080">--璋冪敤榪囩▼<br></span><span style="COLOR: #0000ff">exec</span> modifypwd <span style="COLOR: #ff0000">'admin'</span>,<span style="COLOR: #ff0000">'123456'</span><br><span style="COLOR: #0000ff">exec</span> checkid <span style="COLOR: #ff0000">'admin'</span>,<span style="COLOR: #ff0000">'123456'</span><br><br><span style="COLOR: #008080">--榪斿洖闅忔満瀛楃涓茬殑榪囩▼<br></span><span style="COLOR: #0000ff">create</span> <span style="COLOR: #0000ff">proc</span> randomchar<br>@times <span style="COLOR: #0000ff">int</span>,@result <span style="COLOR: #0000ff">varchar</span>(255) out<br><span style="COLOR: #0000ff">as</span><br><span style="COLOR: #0000ff">declare</span> @k <span style="COLOR: #0000ff">int</span><br><span style="COLOR: #0000ff">declare</span> @r <span style="COLOR: #0000ff">int</span><br><span style="COLOR: #0000ff">declare</span> @i <span style="COLOR: #0000ff">int</span><br><span style="COLOR: #0000ff">declare</span> @s <span style="COLOR: #0000ff">varchar</span>(255)<br><span style="COLOR: #0000ff">set</span> @i=0<br><span style="COLOR: #0000ff">set</span> @s=<span style="COLOR: #ff0000">''</span><br><span style="COLOR: #0000ff">while</span> @i<@times<br><span style="COLOR: #0000ff">begin</span><br><span style="COLOR: #0000ff">set</span> @k=<span style="COLOR: #ff00ff">rand</span>()*61<br><span style="COLOR: #0000ff">if</span> @k<26<br><span style="COLOR: #0000ff">set</span> @r=@k+97<br><span style="COLOR: #0000ff">else</span> <span style="COLOR: #0000ff">if</span> @k>51<br><span style="COLOR: #0000ff">set</span> @r=@k-4<br><span style="COLOR: #0000ff">else</span><br><span style="COLOR: #0000ff">set</span> @r=@k 39 <br><span style="COLOR: #0000ff">set</span> @s=@s <span style="COLOR: #0000ff">char</span>(@r)<br><span style="COLOR: #0000ff">set</span> @i=@i 1<br><span style="COLOR: #0000ff">end</span><br><span style="COLOR: #0000ff">set</span> @result=@s<br><span style="COLOR: #008080">--璋冪敤<br></span><span style="COLOR: #0000ff">declare</span> @s <span style="COLOR: #0000ff">varchar</span>(255)<br><span style="COLOR: #0000ff">exec</span> randomchar 20,@s out </div> <img src ="http://m.shnenglu.com/lilac/aggbug/41071.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://m.shnenglu.com/lilac/" target="_blank">鏉庝簹</a> 2008-01-13 00:11 <a href="http://m.shnenglu.com/lilac/archive/2008/01/13/41071.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>SQL 琛屽垪杞崲http://m.shnenglu.com/lilac/archive/2008/01/13/41069.html鏉庝簹鏉庝簹Sat, 12 Jan 2008 16:10:00 GMThttp://m.shnenglu.com/lilac/archive/2008/01/13/41069.htmlhttp://m.shnenglu.com/lilac/comments/41069.htmlhttp://m.shnenglu.com/lilac/archive/2008/01/13/41069.html#Feedback0http://m.shnenglu.com/lilac/comments/commentRss/41069.htmlhttp://m.shnenglu.com/lilac/services/trackbacks/41069.html--鏅?

鍋囪鏈夊紶瀛︾敓鎴愮嘩琛?CJ)濡備笅
[濮撳悕]  [瀛︾]  [鎴愮嘩]
寮犱笁    璇枃    80
寮犱笁    鏁板    90
寮犱笁    鐗╃悊    85
鏉庡洓    璇枃    85
鏉庡洓    鏁板    92
鏉庡洓    鐗╃悊    82
鐜嬩簲    鏁板    60

鎯沖彉鎴?nbsp;   
[濮撳悕] [璇枃] [鏁板] [鐗╃悊]
寮犱笁   80     90     85
鏉庡洓   85     92     82
鐜嬩簲   null   60     null

declare @sql varchar(4000)
set @sql = 'select 濮撳悕'
select @sql = @sql + ',sum(case 瀛︾ when ''' 瀛︾ ''' then 鎴愮嘩 end) as ' 瀛︾
  from (select distinct 瀛︾ from CJ) as a
set @sql = @sql ' from cj group by 濮撳悕'
exec(@sql)


2. 琛屽垪杞崲--鍚堝茍

鏈夎〃A,
id pid
1   1
1   2
1   3
2   1
2   2
3   1
濡備綍鍖栨垚琛˙:
id pid
  1  1,2,3
  2  1,2
  3  1

鍒涘緩涓涓悎騫剁殑鍑芥暟
create function fmerg(@id int)
returns varchar(8000)
as
begin
declare @str varchar(8000)
set @str=''
select @str=@str ',' cast(pid as varchar) from 琛ˋ where id=@id
set @str=right(@str,len(@str)-1)
return(@str)
end
go

--璋冪敤鑷畾涔夊嚱鏁板緱鍒扮粨鏋?br>select distinct id,dbo.fmerg(id) from 琛ˋ


鏉庝簹 2008-01-13 00:10 鍙戣〃璇勮
]]>
伊人色综合久久天天| 久久av高潮av无码av喷吹| 久久久久人妻一区二区三区 | 无码国产69精品久久久久网站| 97精品依人久久久大香线蕉97| 国产精品99久久免费观看| 欧美日韩精品久久久免费观看| 久久精品国产99国产精品亚洲| 国产精品久久成人影院| 青青热久久国产久精品 | 久久久久久青草大香综合精品| 久久天天婷婷五月俺也去| 精品久久久久久久久午夜福利| 精品久久综合1区2区3区激情| 色88久久久久高潮综合影院| 欧美一区二区精品久久| 一本色道久久综合狠狠躁| 一级做a爰片久久毛片人呢| 日韩久久久久久中文人妻 | 人妻久久久一区二区三区| 久久人人爽人人爽人人片AV麻豆| 日韩精品无码久久久久久| 久久久久国产| 狠狠久久综合伊人不卡| 精品无码久久久久久久久久| 日韩精品久久无码中文字幕| 亚洲国产成人精品无码久久久久久综合| 欧美大香线蕉线伊人久久| 99久久做夜夜爱天天做精品| 国产精品久久久天天影视香蕉| 国产成人久久精品一区二区三区| 久久综合亚洲色HEZYO社区| 蜜桃麻豆www久久国产精品| 国产高潮国产高潮久久久91 | 色综合久久综精品| 久久久久久九九99精品| 无码人妻久久一区二区三区免费| 国产成人精品三上悠亚久久| 久久人做人爽一区二区三区| 久久精品桃花综合| 亚洲国产综合久久天堂 |