SQLÖ®¾Å SQLµÄ°²×°Óë¹ÜÀí
SQL Server °²×°×¢ÒâÊÂÏ£¡
==============================
http://www.cnblogs.com/pvistely/archive/2008/12/31/1365702.html
1. ÐèÒª.Net Framework 3.5£¬ÈôÔÚVista»ò¸ü¸ßµÄOSÉÏÐèÒª3.5 SP1µÄÖ§³Ö£¨ÔÚSQL2008°²×°µÄÇ°»á×Ô¶¯¸üа²×°£©
2. ÐèÒªWidnows PowerShellµÄÖ§³Ö,WPSÊÇÒ»¸ö¹¦Äܷdz£Ç¿´óµÄShellÓ¦Óã¬ÃüÁîÓëDOX/UNIX¼æÈݲ¢Ö§³ÖÖ±½Óµ÷ÓÃ.NETÄ£¿é×öÐÐÃüÁî±à¼£¬ÊǷdz£ÖµµÃÉîÈëÑо¿µÄ¹¤¾ß£¨ÔÚSQL2008°²×°Ê±»á×Ô¶¯¸üа²×°£©
3. ÐèҪȷ±£Windows InstallerµÄ³É¹¦Æô¶¯£¬ÐèÒª4.5ÒÔÉÏ°æ±¾£¨ÐèÒª¼ì²é·þÎñÆô¶¯×´Ì¬service.msc)
4. ÐèÒªMDAC2.8 sp1µÄÖ§³Ö£¨XPÒÔÉÏϵͳÖÐÒѼ¯³É£©
5. Èô»úÆ÷ÉÏÒѾ°²×°Visual studio 2008ÔòÐèÒªVS 2008 sp1ÒÔÉÏ°æ±¾µÄÖ§³Ö
±È½ÏÁ½¸öÊý¾Ý¿â±í½á¹¹µÄ²îÒì
========================
http://www.itwis.com/html/database/sqlserver/20090902/5907.html
ͼ½â¾Û´ØË÷ÒýÓë·Ç¾Û´ØË÷ÒýµÄÇø±ð¼°ÆäÓÅ»¯²éѯ
==============================
http://www.itwis.com/html/database/sqlserver/20090611/4602.html
named pipes
==============================================
"ÃüÃû¹ÜµÀ"»ò"ÃüÃû¹ÜÏß"(Named Pipes)ÊÇÒ»ÖÖ¼òµ¥µÄ½ø³Ì¼äͨÐÅ(I P C)»úÖÆ,
Microsoft Windows NT,Windows 2000,Windows 95ÒÔ¼°Windows 98¾ùÌṩÁ˶ÔËüµÄÖ§³Ö
(µ«²»°üÀ¨Windows CE).ÃüÃû¹ÜµÀ¿ÉÔÚͬһ̨¼ÆËã»úµÄ²»Í¬½ø³ÌÖ®¼ä,»òÔÚ¿çÔ½Ò»¸öÍøÂçµÄ
²»Í¬¼ÆËã»úµÄ²»Í¬½ø³ÌÖ®¼ä,Ö§³Ö¿É¿¿µÄ,µ¥Ïò»òË«ÏòµÄÊý¾ÝͨÐÅ.
ÃüÃû¹ÜµÀÓë TCP/IP Ì×½Ó×Ö
ÔÚ¿ìËÙ¾ÖÓòÍø (LAN) »·¾³ÖУ¬´«Êä¿ØÖÆÐÒé»ò Internet ÐÒé (TCP/IP) Ì×½Ó×Ö¿Í»§¶ËºÍÃüÃû¹ÜµÀ¿Í»§¶ËÔÚÐÔÄÜ·½Ãæ²»ÏàÉÏÏ¡£µ«ÊÇ£¬ÍøÂçËÙ¶ÈÔ½Âý£¨ÈçÔÚ¹ãÓòÍø (WAN) »ò²¦ºÅÍøÂçÉÏ£©£¬TCP/IP Ì×½Ó×Ö¿Í»§¶ËÓëÃüÃû¹ÜµÀ¿Í»§¶ËµÄÐÔÄܲîÒìÔ½Ã÷ÏÔ¡£ÕâÊÇÒòΪ½ø³Ì¼äͨѶ (IPC) »úÖÆÔÚ¶ÔµÈÏî¼äµÄͨѶ·½·¨²»Í¬¡£
¶ÔÓÚÃüÃû¹ÜµÀ£¬Í¨³£ÍøÂçͨÐŽ»»¥ÐÔ¸üÇ¿¡£Ò»¸ö¶ÔµÈÏîÖ±µ½ÁíÒ»¸ö¶ÔµÈÏîʹÓöÁÈ¡ÃüÁîÇëÇóÊý¾Ýʱ²Å·¢ËÍÊý¾Ý¡£ÔÚ¿ªÊ¼¶ÁÈ¡Êý¾ÝÇ°£¬ÍøÂç¶ÁÈ¡Ò»°ã°üÀ¨Ò»ÏµÁпúÊÓÃüÃû¹ÜµÀµÄÐÅÏ¢¡£ÕâÔÚÂýËÙÍøÂçÖпÉÄÜ»¨·Ñ·Ç³£¶à²¢µ¼Ö¹ý¶àµÄÍøÂçÁ÷Á¿£¬ÆäËüµÄÍøÂç¿Í»§¶Ë·´¹ýÀ´Ò²»áÊܵ½Ó°Ïì¡£
²ûÃ÷ËùÌÖÂÛµÄÊDZ¾µØ¹ÜµÀ»¹ÊÇÍøÂç¹ÜµÀÒ²ºÜÖØÒª¡£Èç¹û·þÎñÆ÷Ó
Ïà¹ØÎĵµ£º
½ñÌ죬Óöµ½ÁËÕâÑùµÄÒ»¸öÀý×Ó£º
SQL ServerË÷Òýͳ¼ÆÐÅϢδ¼°Ê±¸üУ¬µ¼ÖÂÅÅÐò»ìÂÒ
ÎÒÃÇÖªµÀ£¬ÔÚsql
serverÉÏ´´½¨Ë÷Òýºó£¬Í¬Ê±»á¶Ô¸ÃË÷ÒýÉϵÄÖµ½øÐÐÅÅÐò£¬µ«¶ÔÓÚÐÂÔö¼ÓµÄÖµ£¬Èç¹ûδÄܼ°Ê±¸üÐÂͳ¼ÆÐÅÏ¢£¬½«ÓпÉÄܵ¼ÖÂÅÅÐòµÄ»ìÂÒ£¬Ò²¾ÍÊÇûÓÐÅÅÐò¡£
ÕâÊDzúÉúÎÊÌâµÄÓï¾ä£º
Select * from V_L_IcStockProInEntry Where FInt ......
ͬһ±í¶à×Ö¶ÎͬʱÖظ´¼Ç¼µÄSQL²éѯ¼°´¦ÀíÊý
±ÈÈçÏÖÔÚÓÐÒ»ÈËÔ±±í £¨±íÃû£ºpeosons£©
ÈôÏ뽫ÐÕÃû¡¢Éí·ÝÖ¤ºÅ¡¢×¡Ö·ÕâÈý¸ö×Ö¶ÎÍêÈ«ÏàͬµÄ¼Ç¼²éѯ³öÀ´
select p1.* from persons p1,persons p2 where p1.idp2.id and p1.cardid = p2.cardid and p1.pname = p2.pname and p1.address ......
Êý¾Ý¿âÃæÊÔ³£ÓòâÊÔÌâ(SQL Server)
ÌâÄ¿1
¡¡¡¡ÎÊÌâÃèÊö:
¡¡¡¡Îª¹ÜÀí¸ÚλҵÎñÅàѵÐÅÏ¢£¬½¨Á¢3¸ö±í:
¡¡¡¡S (S#,SN,SD,SA) S#,SN,SD,SA ·Ö±ð´ú±íѧºÅ¡¢Ñ§Ô±ÐÕÃû¡¢ËùÊôµ¥Î»¡¢Ñ§Ô±ÄêÁä
¡¡¡¡C (C#,CN ) C#,CN ·Ö±ð´ú±í¿Î³Ì±àºÅ¡¢¿Î³ÌÃû³Æ
¡¡¡¡SC ( S#,C#,G ) S#,C#,G ·Ö±ð´ú±íѧºÅ¡¢ËùÑ¡Ð޵Ŀγ̱àºÅ¡¢Ñ§Ï°³É¼¨
¡¡¡¡1. Ê¹Ó ......
Ê×ÏȵÃÏÂÔØÇý¶¯³ÌÐòµ½Î¢ÈíÍøÕ¾ÏÂÔØMicrosoft SQL Server 2005 JDBC Driver 1.2
½âѹMicrosoft SQL Server 2005 jdbc driver1.2.exe£¬°Ñsqljdbc_1.1¸´ÖƵ½%ProgramFiles%£¨Èç¹ûϵͳÔÚCÅÌÔòΪC:\Program Files£©¡£
ÉèÖÃ Classpath
JDBC Çý¶¯³ÌÐò²¢Î´°üº¬ÔÚ Java SDK ÖС£Òò´Ë£¬Èç¹ûҪʹÓøÃÇý¶¯³ÌÐò£¬±ØÐ뽫 classpath ......
½ñÌìÏëÁ¬½ÓSQL Server·þÎñÆ÷ʱ·¢ÏÖû·¨Á¬½Ó£¬·¢Ïֶ˿ںŲ»ÊÇĬÈϵĶ˿ںţ¬ÐèÒªÖ¸¶¨¶Ë¿ÚºÅ£¬¸Õ¿ªÊ¼ÒÔΪÊÇIPµØÖ·¼ÓðºÅÔٶ˿ںžÍÐÐÁË£¬½á¹û·¢ÏÖûÓã¬googleÒ»°Ñ·¢ÏÖÔÀ´²»ÊÇðºÅ£¬ÊǶººÅ£¬¹þ¡£±ÈÈ磺127.0.0.1,1451 , ¸ñʽ¾ÍÊÇ£º[IP],[Port] ¡£ Íê±Ï¡£ ......