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
Ïà¹ØÎĵµ£º
ÓÃoracleÏ°¹ßÁË£¬µ¼³öÓÃexpÓï¾ä£¬Ö±½ÓÉú³ÉdmpÎļþ£¬µ¼ÈëÓÃimpÓï¾ä£¬±í½á¹¹ºÍÊý¾Ýͬʱ¸ã¶¨¡£×î½üÐèÒªÓõ½sqlserver£¬×ÜÊDz»Äܹ»Í¬Ê±µ¼³ö±í½á¹¹ºÍÊý¾Ý£¬googleÉÏ°Ù¶ÈÁ˺ܾÃҲû½â¾ö·½·¨¡£
ÓÒ¼ü--ËùÓÐÈÎÎñ--µ¼³öÊý¾Ý--Ñ¡ÔñÊý¾ÝÔ´£¬Êý¾ÝԴΪÓÃÓÚSQLServerµÄMicrosoft OLE DBÌṩ³ÌÐò£¬Ñ¡ÔñÑéÖ¤·½Ê½ ......
Ñ¡ÔñÖ¸¶¨ÌõÊýÓï¾ä£º
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 ......
ÔÚдSQLʱ£¬ÓÐʱҪ¸ù¾ÝÒÑÓеÄÁÐÖµ¹¹ÔìеÄÁÐÖµ£¬Õâʱ¾ÍÒªÓõ½µÄSQLÖеÄcase¹Ø¼ü×Ö¡£ÈçÏÂËùʾ²éѯ¸ºÔðÈËÐÅÏ¢±í£¨T_MS_CustomerCrmInfoDutyPerson£©ÖеÄÊÇ·ñÊÇÖ÷Òª¸ºÔðÈË£¨isMainDuty£©×ֶΣ¬µ«ÊÇÕâ¸ö×ֶεÄÖµÊÇÒÔö¾ÙµÄ·½Ê½´æ´¢µÄ£¬´æ´¢0±íʾÊÇ·ñ£¬1±íʾÊÇ£¬·ñÔò±íʾδÅжϡ£Õâʱֱ½Ó²éѯ³öµÄÖµ²»ÊÇ ......
×î½üÒòΪҪдһ¸öÊý¾Ý²¢·¢·ÃÎʵĿØÖƳÌÐò£¬ÉÏÍø²éÁËһЩ×ÊÁÏ£¬ÏÖÔÚ¹éÄÉÈçÏ£º ËøµÄ¸ÅÊö Ò». ΪʲôҪÒýÈëËø
¶à¸öÓû§Í¬Ê±¶ÔÊý¾Ý¿âµÄ²¢·¢²Ù×÷ʱ»á´øÀ´ÒÔÏÂÊý¾Ý²»Ò»ÖµÄÎÊÌ⣺
¶ªÊ§¸üÐÂ
A£¬BÁ½¸öÓû§¶ÁͬһÊý¾Ý²¢½øÐÐÐ޸ģ¬ÆäÖÐÒ»¸öÓû§µÄÐ޸Ľá¹ûÆÆ»µÁËÁíÒ»¸öÐ޸ĵĽá ......
·ÖÁ½ÖÖÇé¿ö£º
1¡¢Í¨¹ý½Å±¾·½Ê½£¬2¡¢µ¼Èëµ¼³ö·½Ê½
µ«²»Í¬°æ±¾µÄSqlServer,ÔÚÕâ·½Ãæ²¢²»Ïàͬ¡£
sql2000¶ÔÊý¾Ý¿â¶ÔÏóÖ´ÐÐÉú³É½Å±¾Ê±£¬¾¡¹Ü¶¼Ñ¡Éϸ÷¸öÌõ¼þ£¬µ«¶ÔÓÚ±í¶ÔÏó²¢²»ÄÜ´´½¨Ö÷¼ü
¿ÉÒÔͨ¹ýµ¼Èëµ¼³ö·½Ê½£¬ÔÚµ¼ÈëÄ¿±êÑ¡ÔñÄ¿±êsqlserverºó£¬Ñ¡ÔñÖ»µ¼³ö¶ÔÏó½á¹¹¾ÍºÃÁË¡£
sql2005¶ÔÊý¾Ý¿â¶ÔÏóÖ´ÐÐÉú³É½Å±¾Ê±£¬¿ÉÒÔ´´½¨Ö÷¼ ......