Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÈçºÎÁ¬½Óµ½Áíһ̨»úÆ÷ÉϵÄsql server 2005

 
ÈçºÎÁ¬½Óµ½Áíһ̨»úÆ÷ÉϵÄsql server 2005
 
Ò»¡¢Òª½øÐÐÁ½¸öµØ·½µÄÉèÖÃ
1         µã¿ªÊ¼—³ÌÐò—sql server 2005 –ÅäÖù¤¾ß—sql server 2005Ó¦ÓÃÅäÖÃÆ÷ ,Èçͼ£º
 
 
 
Ñ¡±¾µØÁ¬½ÓºÍÔ¶³ÌÁ¬½ÓÖеĠ ½öʹÓÃtcp/ip»ò  ͬʱʹÓÃtcp/ipºÍnamed pipes
2         µã¿ªÊ¼—³ÌÐò—sql server 2005—ÅäÖù¤¾ß—sql server configuration manger
 
 
ЭÒéÑ¡ ·ñ·ñÊÇ,Ò²¾ÍÊÇÈ«²¿ÕìÌýÑ¡·ñ¡¢ÒÑÑÓ³ÙÑ¡·ñ¡¢ÒÑÆôÓÃÑ¡ÊÇ¡£È»ºóÔÙÑ¡ipµØÖ·Ñ¡Ïî
 
 
 
ÈçͼÓÐÁ½¸öipµØÖ·£¬Ò»¸öÊÇ127.0.0.1,ÁíÒ»¸öÊÇÄãÒªÅäÖõģ¬ÎªÄã»úÆ÷ÉϵÄip µØÖ·£¬tcp¶¯Ì¬¶Ë¿ÚΪ¿Õ£¬tcp¶Ë¿ÚΪ£º1433£¬ÒÑÆôÓãºÊÇ¡£
IPµØÖ·¿ÉÒÔÓÃDOSÖеÄIPCONFIGÃüÁîÀ´²é¿´¡£
µã¿ªÊ¼—ÔËÐЗcmd,È»ºóÔÚDOSÃüÁîÌáʾ·ûÏÂÊäÈëIPCONFIG¡£Èçͼ¡£
 
 
¶þ   ÉÏÃæÁ½¸ö²½ÖèÉèÖúúó£¬Èç¹ûÄãµÄ»úÆ÷ÉÏÓжà¸ösql serverÊý¾Ý¿â£¬×îºÃÒª½«ÆäËûµÄÍ£Ö¹£¬ÒÔ·ÀÖ¹ÕùÓÃ1433¶Ë¿Ú¡£
 
Èý£¬ ÖØÆô  sql server 2005·þÎñ¡£
È»ºó£¬ÄãÒ²¿ÉÒÔÔÚDOSÏÂÊÔÊÔ£¬´ÓÄãµÄ»úÆ÷ºÍÁíÒ»¸ö»úÆ÷·Ö±ðÊÔÊÔÒÔϵÄDOSÃüÁ
TELNET 192.168.3.138 1433  
ÆäÖÐTELNETºóÃæµÄΪÄãSQL SERVER2005»úÆ÷ÉϵĵÄIPµØÖ·¡£Èç¹û³öÏÖºÚÆÁ£¬¹§Ï²Äã³É¹¦À²¡£³ö¹û³öÏÖÏÂÃæµÄ´íÎóÌáʾ£¬ÇëÔÙ¿´¿´ÉÏÃæµÄÉèÖÃÊDz»Êdzö³öÁËÎÊÌâ¡£
 
 
 
 ËÄ ×î½üÒ»²½ÊǵǼ£º
 
 


Ïà¹ØÎĵµ£º

Java Á¬½ÓÊý¾Ý¿â¡¢Ö´ÐÐSQL·â×°Àà

/*µ±Ö´ÐÐSQLʱ·¢ÏÖ²»ÄÜÁ¬½ÓÊý¾Ý¿â£¬ÏÈÖØÁ¬Ò»´Î*/
 
import java.io.FileInputStream;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
......

ÕâÑùµÄsql£¬ÎÒÈ´×öµ½ÁË¡£

 ÕâÊÇÒ»¸öCSDN Oracle¿ª·¢°æ¿éÀï£¬ÍøÓÑÎʹýµÄÒ»µÀÌâ
ÌâÈçÏÂ
create table A_TEST
(
PAYOUT_ITEM_CODE VARCHAR2(30) not
null,
FORMULA_DET VARCHAR2(1000)
)
create table B_TEST
(
ELEMENT_ID VARCHAR2(5) not null,
NAME VARCHAR2(41)
)  
Çóдoracle¶à¸ö×Ö·ûÌæ»»£¨ÓвâÊÔÊý¾Ý£©
inser ......

SQLÖÐDATEADDºÍDATEDIFFµÄÓ÷¨

¹Ì¶¨ÈÕÆÚ¼õÒ»¸öÔ£¨ÈÕ¡¢Ä꣩
dateadd(±í´ïʽ1£¬±í´ïʽ2£¬±í´ïʽ3£©
±í´ïʽ1ΪMM»òYY»òDD
±í´ïʽ2Ϊ1
±í´ïʽ3ΪҪ¼õµÄÈÕÆÚ Ò»¸öÔµĵÚÒ»Ìì µÚÒ»¸öÀý×Ó£¬ÎÒ½«¸æËßÄãÈçºÎ´Óµ±Ç°ÈÕÆÚÈ¥Õâ¸öÔµÄ×îºóÒ»Ìì¡£Çë×¢Ò⣺Õâ¸öÀý×ÓÒÔ¼°ÕâÆªÎÄÕÂÖÐµÄÆäËûÀý×Ó¶¼½«Ö»Ê¹ÓÃDATEDIFFºÍDATEADDº¯ÊýÀ´¼ÆËãÎÒÃÇÏëÒªµÄÈÕ ......

SQlµÄexecute Óësp_executesql¡¡

SQLÓï¾äÀàËÆstring.Format()×é×°±äÁ¿µÄʹÓá£
Ò»°ãÀ´Ëµ£¬ÎÒÃÇ»áÔÚ³ÌÐòÔËÐÐÆÚ¼ä½«ËùÒªÔËÐеÄÃüÁîÓï¾ä×éºÏ³ÉÒ»¸ö×Ö·û´®£¬È»ºóʹÓÃEXECUTEÃüÁî»òϵͳ´æ´¢¹ý³Ì
@0sp_executesqlÀ´ÔËÐС£½ñÌ죬ÎÒÃǽ«À´Ïêϸ̽ÌÖÕâÁ½ÖÖ·½·¨¸÷×ÔµÄÓÅÁӵ㡣
(Ò») ʹÓÃEXECUTEÃüÁîÔËÐÐÃüÁî×Ö·û´®
ҪʹÓÃEXECUTEÃüÁîÀ´ÔËÐÐÒ»¸öÃüÁî×Ö·û´®µÄÓï·¨ÈçÏ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ