锘??xml version="1.0" encoding="utf-8" standalone="yes"?>亚洲爆乳无码专区www,亚洲国模精品一区,亚洲精品乱码久久久久久下载http://www.tkk7.com/Reg/鎴愬姛涓嶆槸灝嗘潵鎵嶆湁鐨?鑰屾槸浠庡喅瀹氬幓鍋氱殑閭d竴鍒昏搗,鎸佺畫绱Н鑰屾垚銆? 涓婁漢鐢熺殑鏃呴旂艦銆傚墠閫斿緢榪?涔熷緢鏆椼傜劧鑰屼笉瑕佹曘備笉鎬曠殑浜虹殑闈㈠墠鎵嶆湁璺?/description>zh-cnSun, 23 Mar 2025 20:56:10 GMTSun, 23 Mar 2025 20:56:10 GMT60MSDN鍛婅瘔浣犵綉鍧http://www.tkk7.com/Reg/archive/2013/04/19/398068.html鑹炬嘗鑹炬嘗Fri, 19 Apr 2013 01:53:00 GMThttp://www.tkk7.com/Reg/archive/2013/04/19/398068.htmlhttp://www.tkk7.com/Reg/comments/398068.htmlhttp://www.tkk7.com/Reg/archive/2013/04/19/398068.html#Feedback0http://www.tkk7.com/Reg/comments/commentRss/398068.htmlhttp://www.tkk7.com/Reg/services/trackbacks/398068.htmlhttp://msdn.itellyou.cn/?lang=zh-cn

鑹炬嘗 2013-04-19 09:53 鍙戣〃璇勮
]]>
緗戠粶綺劇伒(IP鍦板潃鍒囨崲鍣?v2.0.0.3 final <font color=red>闄凙U3婧愮爜</font>錛堟洿鏂幫級http://www.tkk7.com/Reg/archive/2012/06/19/381088.html鑹炬嘗鑹炬嘗Tue, 19 Jun 2012 05:05:00 GMThttp://www.tkk7.com/Reg/archive/2012/06/19/381088.htmlhttp://www.tkk7.com/Reg/comments/381088.htmlhttp://www.tkk7.com/Reg/archive/2012/06/19/381088.html#Feedback0http://www.tkk7.com/Reg/comments/commentRss/381088.htmlhttp://www.tkk7.com/Reg/services/trackbacks/381088.html緗戠粶綺劇伒 v2.0.0.3
杞歡璇存槑錛氶傚悎澶氱綉緇滃姙鍏嬌鐢紝紕板埌鏉杞彁紺猴紝璇峰厑璁擱氳繃錛屽360
搴旂敤騫沖彴錛?a class="linkwin7" >Win7/Vista/WinXP/
杞歡澶у皬錛?96 KB
緙栧啓璇█錛欰U3
浣滆呴偖綆憋細1015208770@163.com
涓嬭澆鍦板潃1錛?/strike>http://www.tkk7.com/Files/Reg/NetworkSpirit.rar(鍐呴儴鍑芥暟璋冪敤鏈夋椂鍊欏嚭鐜頒笉姝e父鐨勯棶棰?
涓嬭澆鍦板潃2錛?a href="http://www.tkk7.com/Files/Reg/NetworkSpirit.rar">http://www.tkk7.com/Files/Reg/NetworkSpirit.zip(榪欎釜鏄?.0.0.4鐗堟湰錛屾洿鏂頒竴涓増鏈彿錛屼慨澶嶄笂涓増鏈唴閮ㄥ嚱鏁拌皟鐢ㄩ棶棰?
婧愮爜鍦板潃1錛?a href="http://www.tkk7.com/Files/Reg/NetworkSpirit(code).rar">http://www.tkk7.com/Files/Reg/NetworkSpirit(code).rar(2.0.0.3婧愮爜)

MD5媯嫻嬶細
鏂囦歡鐗堟湰: 2.0.0.3
淇敼鏃墮棿: 2012-06-19, 12:34:44
MD5: 09CBAE1D6436C4EAE867AB802140E26F
SHA1: 4B2DA60F609948A46989C417E44C17515B8FAA9B
CRC32: D3A9D77E

鏇存柊璇存槑錛?br />1.婧愪唬鐮侀噸鏋?br />2.鍏ㄦ柊UI
3.姝e紡鏇村悕涓虹綉緇滅簿鐏?IP鍦板潃鍒囨崲鍣?

鍔熻兘璇存槑錛?br />1.鏀寔澶氭ā寮忓垏鎹?br />2.鑷姩灞忚斀VMware铏氭嫙緗戝崱璁劇疆
3.鑷姩鍒ゆ柇緗戠嚎鏄惁宸茶繛鎺?br />
杞歡鎴浘錛?br />



鑹炬嘗 2012-06-19 13:05 鍙戣〃璇勮
]]>
<font color=red>advanced systemcare 5.2娉ㄥ唽鐮?lt;/font>http://www.tkk7.com/Reg/archive/2012/04/06/373431.html鑹炬嘗鑹炬嘗Fri, 06 Apr 2012 01:21:00 GMThttp://www.tkk7.com/Reg/archive/2012/04/06/373431.htmlhttp://www.tkk7.com/Reg/comments/373431.htmlhttp://www.tkk7.com/Reg/archive/2012/04/06/373431.html#Feedback6http://www.tkk7.com/Reg/comments/commentRss/373431.htmlhttp://www.tkk7.com/Reg/services/trackbacks/373431.html
涓嬈捐兘鍒嗘瀽緋葷粺鎬ц兘鐡墮鐨勪紭鍖栬蔣浠躲傚畠閫氳繃瀵圭郴緇熷叏鏂逛綅鐨勮瘖鏂紝鎵懼埌緋葷粺鎬ц兘鐨勭摱棰堟墍鍦紝鐒跺悗鏈夐拡瀵規у湴榪涜淇敼銆佷紭鍖栥傛澶栧畠榪樺叿鏈夐棿璋嶈蔣浠跺拰鎭舵剰杞歡鎵弿娓呴櫎鍔熻兘錛屼篃鑳藉皢浣犵殑闅愮淇℃伅浠庣數鑴戜腑鎶歸櫎銆傞拡瀵逛釜浜哄厤璐逛嬌鐢ㄣ侫dvanced
WindowsCare Personal宸叉洿鍚嶄負Advanced SystemCare銆?br />娉ㄥ唽鐮?
79818-39C67-6AD87-1B8D4

鑹炬嘗 2012-04-06 09:21 鍙戣〃璇勮
]]>
Dom4jFactory(璇誨彇鍖呭惈鍛藉悕絀洪棿鐨刋ML錛堟敮鎸佽妭鐐硅鍙栦笉瀹屾暣錛?<font color=red>娣誨姞浣跨敤瀹炰緥</font>http://www.tkk7.com/Reg/archive/2011/12/14/366351.html鑹炬嘗鑹炬嘗Wed, 14 Dec 2011 08:39:00 GMThttp://www.tkk7.com/Reg/archive/2011/12/14/366351.htmlhttp://www.tkk7.com/Reg/comments/366351.htmlhttp://www.tkk7.com/Reg/archive/2011/12/14/366351.html#Feedback2http://www.tkk7.com/Reg/comments/commentRss/366351.htmlhttp://www.tkk7.com/Reg/services/trackbacks/366351.htmlimport java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.dom4j.Document;
import org.dom4j.DocumentException;
import org.dom4j.Element;
import org.dom4j.XPath;
import org.dom4j.io.SAXReader;

/**
 * 璇誨彇鏈夊懡鍚嶇┖闂寸殑XML錛堟敮鎸佽妭鐐硅鍙栦笉瀹屾暣錛?br />  * 
@author Ai Bo
 * 
@version 1.3.1 Date 2011-12-14
 
*/

public class Dom4jFactory {
    
private SAXReader reader = new SAXReader();
    
private Document document;
    
private static Element root;
    
private static Map<String, String> xmlMap = new HashMap<String, String>();

    
public Dom4jFactory(String path) {
        
super();
        
try {
            document 
= reader.read(path);
            root 
= document.getRootElement();
            String defaultNamespace 
= root.getNamespaceURI();
            xmlMap.put(
"default", defaultNamespace);
        }
 catch (DocumentException e) {
            e.printStackTrace();
        }

    }


    
public static List<?> getSelectNodes(String arg0) {
        XPath selector 
= root.createXPath("//default:" + arg0);
        selector.setNamespaceURIs(xmlMap);
        
return selector.selectNodes(root);
    }

    
    @SuppressWarnings(
"unchecked")
    
public <T> T getSelectObject(String arg0){
        List
<?> selectNodes = getSelectNodes(arg0);
        
if(selectNodes.size()==1){
            
return (T) selectNodes.get(0);
        }
else{
            
return null;
        }

    }

}

 XML鏂囦歡:

<?xml version="1.0" encoding="UTF-8"?>
<inputs xmlns="http://input.abio.com.cn" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation
="http://input.abio.com.cn http://www.abio.com.cn/sproinput.xsd">
   
<columns>2</columns>
   
<input id="id"  datatype="String" minlen="1" maxlen="32" casetype="U" width="40" name_zh="鏁版嵁浠g爜" inputtype="text" editable="2" gridwidth="3"></input>
   
<input id="organNo"  datatype="integer" nullable="false" minlen="1" maxlen="20" casetype="U" width="40" name_zh="鏈烘瀯緙栧彿" inputtype="text" editable="2"></input>
   
<input id="organName"  datatype="String" nullable="false" minlen="1" maxlen="20" casetype="U" width="40" name_zh="鏈烘瀯鍚嶇О" inputtype="text" editable="2"></input>
   
<input id="pOrganNo"  datatype="String" nullable="false" minlen="1" maxlen="20" casetype="U" width="40" name_zh="鐖舵満鏋勭紪鍙? inputtype="text" editable="2"></input>
   
<input id="effTime"  datatype="Date" validator="Date" nullable="false" format="yyyy-MM-dd" minlen="8" maxlen="8" casetype="U" width="40" name_zh="鏈夋晥鏃ユ湡" inputtype="date" editable="2"></input>
   
<input id="createUser"  datatype="String" minlen="1" maxlen="20" casetype="U" width="40" name_zh="鍒涘緩浜? inputtype="text" editable="2"></input>
   
<input id="createTime"  datatype="Date" minlen="10" maxlen="20" casetype="U" width="40" name_zh="鍒涘緩鏃ユ湡" editable="2" inputtype="text"></input>
   
<input id="updateUser"  datatype="String"  minlen="1" maxlen="20" casetype="U" width="40" name_zh="鏇存柊浜? inputtype="text" editable="2"></input>
   
<input id="updateTime"  datatype="Date" minlen="10" maxlen="20" casetype="U" width="40" name_zh="鏇存柊鏃ユ湡" editable="2" inputtype="text"></input>
</inputs>

璇誨彇XML鍗曚釜鑺傜偣錛坕nputs涓嬬殑columns鑺傜偣錛?

Dom4jFactory df = new Dom4jFactory("c:\\test.xml");
        DefaultElement columnsitem 
= df.getSelectObject("columns");

璇誨彇XML inputs鑺傜偣涓嬫墍鏈夌殑input鑺傜偣錛?/p>

Dom4jFactory df = new Dom4jFactory("c:\\test.xml");
            List
<DefaultElement> inputNodes = df.getSelectNodes("input");




 



鑹炬嘗 2011-12-14 16:39 鍙戣〃璇勮
]]>
a different object with the same identifier value was already associated with the sessionhttp://www.tkk7.com/Reg/archive/2011/04/05/347655.html鑹炬嘗鑹炬嘗Tue, 05 Apr 2011 14:26:00 GMThttp://www.tkk7.com/Reg/archive/2011/04/05/347655.htmlhttp://www.tkk7.com/Reg/comments/347655.htmlhttp://www.tkk7.com/Reg/archive/2011/04/05/347655.html#Feedback0http://www.tkk7.com/Reg/comments/commentRss/347655.htmlhttp://www.tkk7.com/Reg/services/trackbacks/347655.html榪欎釜閿欒鎴戜竴鍏遍亣鍒拌繃涓ゆ錛屼竴鐩存病鏈夋壘鍒板緢濂界殑瑙e喅鏂規錛岃繖涓敊璇駭鐢熷師鍥犵浉淇″ぇ瀹墮兘鐭ラ亾錛屽洜涓哄湪hibernate涓悓涓涓猻ession閲岄潰鏈変簡涓や釜鐩稿悓鏍囪瘑浣嗘槸鏄笉鍚屽疄浣?
涓寮濮嬫寜緗戜笂璇寸殑鐢╯ession.merge(Object)鎶ヤ簡涓涓敊錛屽彲鑳芥槸娌℃湁鐢ㄥソ錛屾敼鐢?nbsp;session.clear(); session.update(user);榪欐牱灝監K浜?
鏂規硶涓猴細

package org.springframework.orm.hibernate3.support;

    
public void modifyByMerge(User user) {
        Session session 
= getHibernateTemplate().getSessionFactory().
                          getCurrentSession();
        session.clear();
        session.update(user);
    }

欏圭洰鐢ㄧ殑鏄痵pring 
+ hibernate鎵浠ュ緱鐢╣etHibernateTemplate().getSessionFactory().getCurrentSession();寰楀綋鍓峉ession



鑹炬嘗 2011-04-05 22:26 鍙戣〃璇勮
]]>
鏁版嵁搴撴湇鍔$鐞嗗伐鍏?V2.0.0.1(鍘熷垱錛屾湜澶у鎷嶇爾)http://www.tkk7.com/Reg/archive/2011/03/30/347285.html鑹炬嘗鑹炬嘗Wed, 30 Mar 2011 07:23:00 GMThttp://www.tkk7.com/Reg/archive/2011/03/30/347285.htmlhttp://www.tkk7.com/Reg/comments/347285.htmlhttp://www.tkk7.com/Reg/archive/2011/03/30/347285.html#Feedback1http://www.tkk7.com/Reg/comments/commentRss/347285.htmlhttp://www.tkk7.com/Reg/services/trackbacks/347285.html鏁版嵁搴撴湇鍔$鐞嗗伐鍏?nbsp;V2.0.0.1
鍒涘涔嬪垵:鍦ㄥ紑鍙戣繃紼嬩腑錛岀儲浜庢瘡嬈″紑鏈哄悗閮借鐢ㄥ懡浠ゆ墦寮servers.msc鍚姩鏈嶅姟錛屾垨鑰呮妸瑕佸惎鍔ㄧ殑鏈嶅姟鍐欐垚涓涓狟AT 鏂囦歡榪愯鏈嶅姟銆傛垜鏈夌偣涓嶅お鍠滄榛戝拷蹇界殑紿楀彛錛屾墍浠ヤ簡鐢ˋU3鍐欎簡涓皬紼嬪簭鐢ㄦ潵綆$悊榪欎簺鏈嶅姟銆?br /> 鍔熻兘錛?br /> 1.鏀寔oracle,sqlserver,mysql鏁版嵁搴撴湇鍔?br /> 2.鏀寔璁劇疆鏈嶅姟鍚姩妯″紡
3.鏀寔鎵歸噺鍚姩鏈嶅姟
4.鏀寔Windows(XP,VISTA,2008,7),鍏朵粬Windows緋葷粺鐢變簬鏃墮棿闂娌℃潵寰楁ユ祴璇曘?br /> 娉ㄦ剰:
1.oracle鐨勭洃鍚櫒蹇呴渶閰嶇疆姝g‘(涓嬬増灝嗘敼榪涜繖涓棶棰?

鏈湴涓嬭澆:http://www.tkk7.com/Files/Reg/鏁版嵁搴撴湇鍔$鐞嗗伐鍏?rar
鍒嗘祦鍦板潃:http://down.51cto.com/data/184705

鑹炬嘗 2011-03-30 15:23 鍙戣〃璇勮
]]>
鏄劇ずsql server鐨勬煡璇㈣鍙ヨ繍琛屾椂闂達紝鍏蜂綋鍒版縐?/title><link>http://www.tkk7.com/Reg/archive/2011/03/18/346546.html</link><dc:creator>鑹炬嘗</dc:creator><author>鑹炬嘗</author><pubDate>Fri, 18 Mar 2011 08:31:00 GMT</pubDate><guid>http://www.tkk7.com/Reg/archive/2011/03/18/346546.html</guid><wfw:comment>http://www.tkk7.com/Reg/comments/346546.html</wfw:comment><comments>http://www.tkk7.com/Reg/archive/2011/03/18/346546.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.tkk7.com/Reg/comments/commentRss/346546.html</wfw:commentRss><trackback:ping>http://www.tkk7.com/Reg/services/trackbacks/346546.html</trackback:ping><description><![CDATA[<div style="border-bottom: #cccccc 1px solid; border-left: #cccccc 1px solid; padding-bottom: 4px; background-color: #eeeeee; padding-left: 4px; width: 98%; padding-right: 5px; font-size: 13px; word-break: break-all; border-top: #cccccc 1px solid; border-right: #cccccc 1px solid; padding-top: 4px"><span style="color: #0000ff">declare</span><span style="color: #000000">   </span><span style="color: #008000">@ct</span><span style="color: #000000">   </span><span style="color: #000000; font-weight: bold">datetime</span><span style="color: #000000">   <br />   </span><span style="color: #0000ff">set</span><span style="color: #000000">   </span><span style="color: #008000">@ct</span><span style="color: #000000">   </span><span style="color: #808080">=</span><span style="color: #000000">   </span><span style="color: #ff00ff">getdate</span><span style="color: #000000">()   <br />   </span><span style="color: #008080">--</span><span style="color: #008080">-   </span><span style="color: #008080"><br /> </span><span style="color: #000000">  </span><span style="color: #008080">--</span><span style="color: #008080">sql   璇彞   </span><span style="color: #008080"><br /> </span><span style="color: #000000"><br />   </span><span style="color: #008080">--</span><span style="color: #008080">-   </span><span style="color: #008080"><br /> </span><span style="color: #000000">  </span><span style="color: #0000ff">select</span><span style="color: #000000">   </span><span style="color: #ff00ff">datediff</span><span style="color: #000000">(ms,   </span><span style="color: #008000">@ct</span><span style="color: #000000">   ,</span><span style="color: #ff00ff">getdate</span><span style="color: #000000">())   </span><span style="color: #0000ff">as</span><span style="color: #000000">   </span><span style="color: #ff0000">'</span><span style="color: #ff0000">鏌ヨ鏃墮棿錛堟縐掞級</span><span style="color: #ff0000">'</span><span style="color: #000000"> <br /> </span></div> <img src ="http://www.tkk7.com/Reg/aggbug/346546.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.tkk7.com/Reg/" target="_blank">鑹炬嘗</a> 2011-03-18 16:31 <a href="http://www.tkk7.com/Reg/archive/2011/03/18/346546.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>鏍?Oracle鐢⊿tart with...Connect By瀛愬彞閫掑綊鏌ヨhttp://www.tkk7.com/Reg/archive/2011/03/16/346370.html鑹炬嘗鑹炬嘗Wed, 16 Mar 2011 03:30:00 GMThttp://www.tkk7.com/Reg/archive/2011/03/16/346370.htmlhttp://www.tkk7.com/Reg/comments/346370.htmlhttp://www.tkk7.com/Reg/archive/2011/03/16/346370.html#Feedback0http://www.tkk7.com/Reg/comments/commentRss/346370.htmlhttp://www.tkk7.com/Reg/services/trackbacks/346370.htmlStart withConnect By瀛愬彞閫掑綊鏌ヨ涓鑸敤浜庝竴涓〃緇存姢鏍戝艦緇撴瀯鐨勫簲鐢ㄣ?br /> 鍒涘緩紺轟緥琛細
CREATE TABLE TBL_TEST
(
  ID    
NUMBER,
  NAME  
VARCHAR2(100 BYTE),
  PID   
NUMBER                                  DEFAULT 0
);
 
鎻掑叆嫻嬭瘯鏁版嵁錛?br />
INSERT INTO TBL_TEST(ID,NAME,PID) VALUES('1','10','0');
INSERT INTO TBL_TEST(ID,NAME,PID) VALUES('2','11','1');
INSERT INTO TBL_TEST(ID,NAME,PID) VALUES('3','20','0');
INSERT INTO TBL_TEST(ID,NAME,PID) VALUES('4','12','1');
INSERT INTO TBL_TEST(ID,NAME,PID) VALUES('5','121','2');
 
浠嶳oot寰鏍戞湯姊㈤掑綊
select * from TBL_TEST
 start 
with id=1
 connect 
by prior id = pid
 
浠庢湯姊㈠線鏍慠OOT閫掑綊
select * from TBL_TEST
 start 
with id=5
 connect 
by prior pid = id
=====
瀵逛簬oracle榪涜綆鍗曟爲鏌ヨ(閫掑綊鏌ヨ)

DEPTID PAREDEPTID NAME 
NUMBER NUMBER CHAR (40 Byte) 
閮ㄩ棬id 鐖墮儴闂╥d(鎵灞為儴闂╥d) 閮ㄩ棬鍚嶇О 


閫氳繃瀛愯妭鐐瑰悜鏍硅妭鐐硅拷鏈?

Sql浠g爜 
1.select * from persons.dept start with deptid=76 connect by prior paredeptid=deptid   
Sql浠g爜  
1.select * from persons.dept start with deptid=76 connect by prior paredeptid=deptid   
 
select * from persons.dept start with deptid=76 connect by prior paredeptid=deptid  

閫氳繃鏍硅妭鐐歸亶鍘嗗瓙鑺傜偣. 

Sql浠g爜 
1.select * from persons.dept start with paredeptid=0 connect by prior deptid=paredeptid   
Sql浠g爜  
1.select * from persons.dept start with paredeptid=0 connect by prior deptid=paredeptid   
select * from persons.dept start with paredeptid=0 connect by prior deptid=paredeptid  

鍙氳繃level 鍏抽敭瀛楁煡璇㈡墍鍦ㄥ眰嬈? 

Sql浠g爜 
1.select a.*,level from persons.dept a start with paredeptid=0 connect by prior deptid=paredeptid   
Sql浠g爜  
1.select a.*,level from persons.dept a start with paredeptid=0 connect by prior deptid=paredeptid   
select a.*,level from persons.dept a start with paredeptid=0 connect by prior deptid=paredeptid  

鍐嶆澶嶄範涓涓?start 
with connect by 鐨勭敤娉曪紝 start with 鍚庨潰鎵璺熺殑灝辨槸灝辨槸閫掑綊鐨勭瀛愩?nbsp;

閫掑綊鐨勭瀛愪篃灝辨槸閫掑綊寮濮嬬殑鍦版柟 connect 
by 鍚庨潰鐨?prior" 濡傛灉緙虹渷錛氬垯鍙兘鏌ヨ鍒扮鍚堟潯浠剁殑璧峰琛岋紝騫朵笉榪涜閫掑綊鏌ヨ錛?nbsp;

connect 
by prior 鍚庨潰鎵鏀劇殑瀛楁鏄湁鍏崇郴鐨勶紝瀹冩寚鏄庝簡鏌ヨ鐨勬柟鍚戙?nbsp;

緇冧範錛?nbsp;閫氳繃瀛愯妭鐐硅幏寰楅《鑺傜偣 

Sql浠g爜 
1.select FIRST_VALUE(deptid) OVER (ORDER BY LEVEL DESC ROWS UNBOUNDED PRECEDING) AS firstdeptid from persons.dept start with deptid=76 connect by prior paredeptid=deptid  
====榪欑鏂規硶鍙槸褰撹〃閲屽氨鏈変竴棰楁爲,澶氭5鏍戞庝箞鍔烇紵

.澹版槑錛欽avaEye鏂囩珷鐗堟潈灞炰簬浣滆咃紝鍙楁硶寰嬩繚鎶ゃ傛病鏈変綔鑰呬功闈㈣鍙笉寰楄漿杞姐?nbsp;


鑹炬嘗 2011-03-16 11:30 鍙戣〃璇勮
]]>
SQLSERVER 瀛楃鍑芥暟鏁寸悊http://www.tkk7.com/Reg/archive/2011/03/16/346369.html鑹炬嘗鑹炬嘗Wed, 16 Mar 2011 03:17:00 GMThttp://www.tkk7.com/Reg/archive/2011/03/16/346369.htmlhttp://www.tkk7.com/Reg/comments/346369.htmlhttp://www.tkk7.com/Reg/archive/2011/03/16/346369.html#Feedback0http://www.tkk7.com/Reg/comments/commentRss/346369.htmlhttp://www.tkk7.com/Reg/services/trackbacks/346369.html銆銆/* 瀛楃鍑芥暟 */
銆銆
/* 榪斿洖瀛楃琛ㄨ揪寮忎腑鏈宸︿晶瀛楃鐨凙SCII浠g爜鍊?nbsp;*/
銆銆
select Ascii(‘a‘) --a:97,A:65
銆銆/* 灝嗘暣鏁癆SCII浠g爜杞崲涓哄瓧絎?nbsp;*/
銆銆
select Char(97)--97:a,65:A
銆銆/* 榪斿洖琛ㄨ揪寮忎腑鎸囧畾瀛楃鐨勫紑濮嬩綅緗?nbsp;*/
銆銆
select Charindex(‘b‘,‘abcdefg‘,5)
銆銆
/* 浠ユ暣鏁拌繑鍥炰袱涓瓧絎﹁〃杈懼紡鐨凷OUNDEX鍊間箣宸?nbsp;*/
銆銆
select Difference(‘bet‘,‘bit‘)--3
銆銆/* 榪斿洖瀛楃琛ㄨ揪寮忔渶宸︿晶鎸囧畾鏁扮洰鐨勫瓧絎?nbsp;*/
銆銆
select Left(‘abcdefg‘,3)--abc
銆銆/* 榪斿洖緇欏畾瀛楃涓茶〃杈劇殑瀛楃鏁?nbsp;*/
銆銆
select Len(‘abcdefg‘)--7
銆銆/* 榪斿洖灝嗗ぇ鍐欏瓧絎﹁漿鎹負灝忓瓧絎︾殑瀛楃琛ㄨ揪寮?nbsp;*/
銆銆
select Lower(‘ABCDEFG‘)--abcdefg
銆銆/* 榪斿洖鍒犻櫎浜嗗墠瀵肩┖鏍間箣鍚庡瓧絎﹁〃杈懼紡 */
銆銆
select Ltrim(‘銆銆 abcdefg‘)--abcdefg
銆銆/* 榪斿洖鍏鋒湁緇欏畾鐨勬暣鏁頒唬鐮佺殑UNICODE瀛楃 */
銆銆
select Nchar(65)--A
銆銆/* 榪斿洖鎸囧畾琛ㄨ揪寮忎腑妯″紡絎竴嬈″嚭鐜扮殑寮濮嬩綅緗?nbsp;*/
銆銆
select Patindex(‘%_cd%‘,‘abcdefg‘)--2
銆銆/* 榪斿洖涓烘垚涓烘湁鏁堢殑SQL SERVER鍒嗛殧鏍囪瘑絎﹁屾坊鍔犱簡鍒嗛殧絎︾殑UNICODE瀛楃涓?nbsp;*/
銆銆
select Quotename(‘create table‘)
銆銆
/* 鐢ㄧ涓変釜琛ㄨ揪寮忔浛鎹㈢涓涓〃杈懼紡涓嚭鐜扮殑絎簩涓〃杈懼紡 */
銆銆
select Replace(‘abcdefg‘,‘cd‘,‘xxx‘)--abxxxefg
銆銆/* 鎸夋寚瀹氭鏁伴噸澶嶈〃杈懼紡 */
銆銆
select Replicate(‘abc|‘,4)--abc|abc|abc|abc|
銆銆/* 榪斿洖瀛楃琛ㄨ揪寮忕殑閫嗗悜琛ㄨ揪寮?nbsp;*/
銆銆
select Reverse(‘abc‘)--cba
銆銆/* 榪斿洖瀛楃琛ㄨ揪寮忓彸渚ф寚瀹氭暟鐩殑瀛楃 */
銆銆
select Right(‘abcd‘,3)--bcd
銆銆/* 榪斿洖鎴柇浜嗘墍鏈夊熬闅忕┖鏍間箣鍚庣殑瀛楃琛ㄨ揪寮?nbsp;*/
銆銆
select Rtrim(‘abcd銆銆銆 ‘)--abcd
銆銆/* 榪斿洖鐢卞洓涓瓧絎﹁〃杈劇殑SOUNDEX浠g爜 */
銆銆
select Soundex(‘abcd‘)--A120
銆銆/* 榪斿洖鐢遍噸澶嶇┖鏍肩粍鎴愮殑瀛楃涓?nbsp;*/
銆銆
select Space(10)--[銆銆]
銆銆/* 榪斿洖浠庨粯璁よ〃杈捐漿鎹㈣屾潵鐨勫瓧絎︿覆 */
銆銆
select Str(100)--[銆銆銆銆 100]
銆銆/*銆 */
銆銆
select Str(100,3)--[100]
銆銆/*銆 */
銆銆
select Str(14.4444,5,4)--[14.44]
銆銆/* 鍒犻櫎鎸囧畾闀垮害鐨勫瓧絎?騫跺湪鎸囧畾鐨勮搗鐐瑰鎻掑叆鍙︿竴緇勫瓧絎?nbsp;*/
銆銆
select Stuff(‘abcdefg‘,2,4,‘xxx‘)--axxxfg
銆銆/* 榪斿洖瀛楃琛ㄨ揪寮?浜岃繘鍒?鏂囨湰琛ㄨ揪寮忔垨鍥懼儚琛ㄨ揪鐨勪竴閮ㄥ垎 */
銆銆
select Substring(‘abcdefg‘,2,3)--bcd
銆銆/* 榪斿洖琛ㄨ揪絎竴涓瓧絎︾殑UNICODE鏁存暟鍊?nbsp;*/
銆銆
select Unicode(‘a‘)--97
銆銆/* 榪斿洖灝嗗皬鍐欏瓧絎﹁漿鎹負澶у啓瀛楃鐨勫瓧絎﹁〃杈懼紡 */
銆銆
select Upper(‘a‘)--‘A‘

鑹炬嘗 2011-03-16 11:17 鍙戣〃璇勮
]]>
SQLSERVER 鏁板瓧鏍煎紡鍖?/title><link>http://www.tkk7.com/Reg/archive/2011/03/15/346336.html</link><dc:creator>鑹炬嘗</dc:creator><author>鑹炬嘗</author><pubDate>Tue, 15 Mar 2011 09:57:00 GMT</pubDate><guid>http://www.tkk7.com/Reg/archive/2011/03/15/346336.html</guid><wfw:comment>http://www.tkk7.com/Reg/comments/346336.html</wfw:comment><comments>http://www.tkk7.com/Reg/archive/2011/03/15/346336.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.tkk7.com/Reg/comments/commentRss/346336.html</wfw:commentRss><trackback:ping>http://www.tkk7.com/Reg/services/trackbacks/346336.html</trackback:ping><description><![CDATA[<div style="border-bottom: #cccccc 1px solid; border-left: #cccccc 1px solid; padding-bottom: 4px; background-color: #eeeeee; padding-left: 4px; width: 98%; padding-right: 5px; font-size: 13px; word-break: break-all; border-top: #cccccc 1px solid; border-right: #cccccc 1px solid; padding-top: 4px"><span style="color: #ff00ff">Cast</span><span style="color: #000000">(</span><span style="color: #ff00ff">round</span><span style="color: #000000">((a.M_weight</span><span style="color: #808080">*</span><span style="color: #000000">a.length</span><span style="color: #808080">*</span><span style="color: #000000">a.R_NUMBER),</span><span style="color: #800000; font-weight: bold">2</span><span style="color: #000000">) </span><span style="color: #0000ff">as</span><span style="color: #000000"> numeric(</span><span style="color: #800000; font-weight: bold">12</span><span style="color: #000000">,</span><span style="color: #800000; font-weight: bold">2</span><span style="color: #000000">))total</span></div> <img src ="http://www.tkk7.com/Reg/aggbug/346336.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.tkk7.com/Reg/" target="_blank">鑹炬嘗</a> 2011-03-15 17:57 <a href="http://www.tkk7.com/Reg/archive/2011/03/15/346336.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item></channel></rss> <footer> <div class="friendship-link"> <p>感谢您访问我们的网站,您可能还对以下资源感兴趣:</p> <a href="http://www.tkk7.com/" title="亚洲av成人片在线观看">亚洲av成人片在线观看</a> <div class="friend-links"> </div> </div> </footer> 主站蜘蛛池模板: <a href="http://yg1617.com" target="_blank">日本免费污片中国特一级</a>| <a href="http://gdbobo.com" target="_blank">h片在线播放免费高清 </a>| <a href="http://xabcjzx.com" target="_blank">久久精品国产亚洲Aⅴ香蕉</a>| <a href="http://010youhua.com" target="_blank">女人张开腿等男人桶免费视频</a>| <a href="http://www-63228.com" target="_blank">免费污视频在线观看</a>| <a href="http://778002.com" target="_blank">国产免费网站看v片在线</a>| <a href="http://sdkjkj.com" target="_blank">久久精品电影免费动漫</a>| <a href="http://295301.com" target="_blank">妞干网免费观看视频</a>| <a href="http://www-33758.com" target="_blank">久久久亚洲AV波多野结衣</a>| <a href="http://htsp777.com" target="_blank">亚洲欧洲视频在线观看</a>| <a href="http://hhgcnet.com" target="_blank">亚洲人成www在线播放</a>| <a href="http://jx-dirui.com" target="_blank">涩涩色中文综合亚洲</a>| <a href="http://tao-zhe.com" target="_blank">久久香蕉国产线看免费</a>| <a href="http://df8848.com" target="_blank">国产啪亚洲国产精品无码</a>| <a href="http://s88s88.com" target="_blank">精品一区二区三区无码免费直播 </a>| <a href="http://av520av.com" target="_blank">精品女同一区二区三区免费站</a>| <a href="http://jx-dirui.com" target="_blank">四虎影视成人永久免费观看视频 </a>| <a href="http://xzdlgp.com" target="_blank">一级毛片免费播放</a>| <a href="http://aa77cc.com" target="_blank">亚洲免费观看视频</a>| <a href="http://zjszbwzl.com" target="_blank">亚洲国产成人综合</a>| <a href="http://xyhfloor.com" target="_blank">免费人妻精品一区二区三区</a>| <a href="http://zz773.com" target="_blank">成年网在线观看免费观看网址</a>| <a href="http://yaboxxx125.com" target="_blank">中国一级特黄的片子免费</a>| <a href="http://xzdlgp.com" target="_blank">亚洲一区免费视频</a>| <a href="http://dsfv1.com" target="_blank">亚洲男女性高爱潮网站</a>| <a href="http://zndijgch.com" target="_blank">久久免费精品视频</a>| <a href="http://xxnxgay.com" target="_blank">久久亚洲国产精品成人AV秋霞</a>| <a href="http://ac839.com" target="_blank">久久国产乱子精品免费女 </a>| <a href="http://626632.com" target="_blank">成人片黄网站A毛片免费</a>| <a href="http://ldcatv.com" target="_blank">一级毛片直播亚洲</a>| <a href="http://szq18888.com" target="_blank">亚洲高清中文字幕综合网</a>| <a href="http://1897tao.com" target="_blank">黄网站免费在线观看</a>| <a href="http://www-92109.com" target="_blank">亚洲色成人WWW永久网站</a>| <a href="http://ccc321.com" target="_blank">久久九九久精品国产免费直播</a>| <a href="http://zzhjnmzp.com" target="_blank">精品无码免费专区毛片</a>| <a href="http://tao-zhe.com" target="_blank">亚洲自偷精品视频自拍</a>| <a href="http://8dfk.com" target="_blank">日本片免费观看一区二区</a>| <a href="http://haidiaori.com" target="_blank">91午夜精品亚洲一区二区三区</a>| <a href="http://www-188588.com" target="_blank">无码人妻精品中文字幕免费东京热</a>| <a href="http://jxszzhzs.com" target="_blank">日韩免费观看的一级毛片</a>| <a href="http://dbyssw.com" 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>