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

MyEclipseÖÐÅäÖÃSQLServer 2005Êý¾Ý¿â

1.°²×°ºÃSQLServer 2005Êý¾Ý¿âÈí¼þ£¬½Ó×Å×îÖØÒªµÄ¾ÍÊÇ°²×°Êý¾Ý¿âÇý¶¯SQL Server 2005 driver for JDBC£¬¿ÉÒÔµ½:http://download.microsoft.com/download/8/B/D/8BDABAE2-B6EA-41D4-B903-7916EF3690EF/sqljdbc_1.2.2323.101_enu.exeÏÂÔØ
2.½«JDBC½âѹµ½ÈÎÒâµÄλÖã¬ÔÚ°²×°Ä¿Â¼ÀïÕÒµ½sqljdbc.jarÎļþ£¬ÒÔÇ°µÄÎÄÕÂÖÐÒѾ­½²¹ý»·¾³±äÁ¿µÄÅäÖã¬ÕâÀïÒª¼ÓÒ»µã£¬ÔÚclasspathÀïÔÙ¼ÓÉÏsqljdbc.jarµÄ·¾¶£¬±ÈÈçC:\Program Files\Java\sqljdbc_1.2\enu\sqljdbc.jar£»
3.ÉèÖÃSQLEXPRESS·þÎñÆ÷:
a.                               ´ò¿ªSQL Server Configuration Manager -> SQLEXPRESSµÄЭÒé -> TCP/IP
                         
b.                               ÓÒ¼üµ¥»÷Æô¶¯TCP/IP£¬Ë«»÷½øÈëÊôÐÔ,°ÑIPµØÖ·ÖеÄIP allÖеÄTCP¶Ë¿ÚÉèÖÃΪ1433£¬ÒÑÆôÓøÄΪ“ÊÇ”
                 
c.                               ÖØÐÂÆô¶¯·þÎñÆ÷
ÔÚËùÑ¡ÏîÓÒ»÷£¬ÖØÐÂÆô¶¯
            
d.                               ¹Ø±ÕSQL Server Configuration Manager
4.ÔÚMyEclipseÖУ¬´°¿Ú->Ê×Ñ¡Ïî->java->installed JRE  ±à¼­ÒѾ­°²×°ºÃµÄjdk,²éÕÒĿ¼Ìí¼Ósqljdbc.jar
5.ÓÒ¼üµ¥»÷Ŀ¼´°¿ÚÖеÄTest, Ñ¡ÔñBuild Path ->Configure Build Path..., Ìí¼ÓÀ©Õ¹jar


Ïà¹ØÎĵµ£º

sqlserverͬʱµ¼³ö±í½á¹¹ºÍÊý¾Ý

ÓÃoracleÏ°¹ßÁË£¬µ¼³öÓÃexpÓï¾ä£¬Ö±½ÓÉú³ÉdmpÎļþ£¬µ¼ÈëÓÃimpÓï¾ä£¬±í½á¹¹ºÍÊý¾Ýͬʱ¸ã¶¨¡£×î½üÐèÒªÓõ½sqlserver£¬×ÜÊDz»Äܹ»Í¬Ê±µ¼³ö±í½á¹¹ºÍÊý¾Ý£¬googleÉÏ°Ù¶ÈÁ˺ܾÃҲû½â¾ö·½·¨¡£
ÓÒ¼ü--ËùÓÐÈÎÎñ--µ¼³öÊý¾Ý--Ñ¡ÔñÊý¾ÝÔ´£¬Êý¾ÝԴΪÓÃÓÚSQLServerµÄMicrosoft OLE DBÌṩ³ÌÐò£¬Ñ¡ÔñÑéÖ¤·½Ê½ ......

db2\infomix\oralce\sqlserverÑ¡ÔñÖ¸¶¨ÌõÊýÓï¾ä

Ñ¡ÔñÖ¸¶¨ÌõÊýÓï¾ä£º
db2£ºselect * from tabname fetch frist n rows only
informix£ºselect first n *
from tabname
oralce£ºselect * from tabname where rownum <= n
sql server :select top n * from tabname ......

sqlServer,oracleÖÐcase¹Ø¼ü×ÖµÄÓ÷¨

    ÔÚдSQLʱ£¬ÓÐʱҪ¸ù¾ÝÒÑÓеÄÁÐÖµ¹¹ÔìеÄÁÐÖµ£¬Õâʱ¾ÍÒªÓõ½µÄSQLÖеÄcase¹Ø¼ü×Ö¡£ÈçÏÂËùʾ²éѯ¸ºÔðÈËÐÅÏ¢±í£¨T_MS_CustomerCrmInfoDutyPerson£©ÖеÄÊÇ·ñÊÇÖ÷Òª¸ºÔðÈË£¨isMainDuty£©×ֶΣ¬µ«ÊÇÕâ¸ö×ֶεÄÖµÊÇÒÔö¾ÙµÄ·½Ê½´æ´¢µÄ£¬´æ´¢0±íʾÊÇ·ñ£¬1±íʾÊÇ£¬·ñÔò±íʾδÅжϡ£Õâʱֱ½Ó²éѯ³öµÄÖµ²»ÊÇ ......

SQLServerµÄËø»úÖÆ

×î½üÒòΪҪдһ¸öÊý¾Ý²¢·¢·ÃÎʵĿØÖƳÌÐò£¬ÉÏÍø²éÁËһЩ×ÊÁÏ£¬ÏÖÔÚ¹éÄÉÈçÏ£º ËøµÄ¸ÅÊö Ò». ΪʲôҪÒýÈëËø
¶à¸öÓû§Í¬Ê±¶ÔÊý¾Ý¿âµÄ²¢·¢²Ù×÷ʱ»á´øÀ´ÒÔÏÂÊý¾Ý²»Ò»ÖµÄÎÊÌ⣺
¶ªÊ§¸üÐÂ
A£¬BÁ½¸öÓû§¶ÁͬһÊý¾Ý²¢½øÐÐÐ޸ģ¬ÆäÖÐÒ»¸öÓû§µÄÐ޸Ľá¹ûÆÆ»µÁËÁíÒ»¸öÐ޸ĵĽá ......

ÔÚ²»Í¬sqlserver·þÎñÆ÷¼ä£¬´´½¨ÏàͬÊý¾Ý¿â¶ÔÏó¡£

·ÖÁ½ÖÖÇé¿ö£º
1¡¢Í¨¹ý½Å±¾·½Ê½£¬2¡¢µ¼Èëµ¼³ö·½Ê½
µ«²»Í¬°æ±¾µÄSqlServer,ÔÚÕâ·½Ãæ²¢²»Ïàͬ¡£
sql2000¶ÔÊý¾Ý¿â¶ÔÏóÖ´ÐÐÉú³É½Å±¾Ê±£¬¾¡¹Ü¶¼Ñ¡Éϸ÷¸öÌõ¼þ£¬µ«¶ÔÓÚ±í¶ÔÏó²¢²»ÄÜ´´½¨Ö÷¼ü
¿ÉÒÔͨ¹ýµ¼Èëµ¼³ö·½Ê½£¬ÔÚµ¼ÈëÄ¿±êÑ¡ÔñÄ¿±êsqlserverºó£¬Ñ¡ÔñÖ»µ¼³ö¶ÔÏó½á¹¹¾ÍºÃÁË¡£
sql2005¶ÔÊý¾Ý¿â¶ÔÏóÖ´ÐÐÉú³É½Å±¾Ê±£¬¿ÉÒÔ´´½¨Ö÷¼ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ