MS sql serverɾ³ý·þÎñÆ÷×é...
֮ǰΪÁË·½±ã²Ù×÷¾ÍÔÚSql ServerµÄÆóÒµ¹ÜÀíÆ÷Àï×¢²áÁËÔ¶³Ì·þÎñÆ÷£¬µ«ÊÇÇ°Ò»¶Îʱ¼äÔÚÔ¶³Ì·þÎñÆ÷ÉÏÐÞ¸ÄÁ˸ÃÊý¾Ý¿âµÄÃÜÂ룬ÿ´Îµã»÷¸Ã×¢²á·þÎñÆ÷ϵͳҪµÈºÜ³¤Ê±¼ä£¬ÏóËÀ»úÒ»Ñù£»ÐÞ¸ÄÁ¬½ÓÊôÐÔÒ²Ð޸IJ»ÁË£¬µã»÷ºóҲûÓз´Ó¦£¬ÓÚÊǾÍÏëɾ³ýÖØÐÂ×¢²á£¬¼ÈÈ»ÎÞ·¨ÔÚ¹ÜÀíÆ÷Àïɾ³ý£¬¾ÍÏë´Ó×¢²á±íÀïɾ³ý£¬ÕÒÁ˺þÃÖÕÓÚÕÒµ½ÁË£¬¶ÔÓ¦µÄsql serverµÄ×¢²á·þÎñÆ÷ÔÚ£º
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X\SQL Server ×éÖУ¬
Ö±½Óɾ³ýÄãÄãҪɾ³ýµÄÄǸö×¢²áÃû¾Í¿ÉÒÔ
ÔÚMSSQLÆóÒµ¹ÜÀíÆ÷Ìí¼ÓµÄ×¢²áµÄSQL·þÎñÆ÷ºó£¬Èç¹ûijÌìÒѾע²áºÃµÄSQL·þÎñÆ÷²»´æÔÚÁË£¬»òÕ߸ü»»IPÁË£¬ÄÇôÂé·³¾ÍÀ´ÁË£¬Ïëɾ³ýËü¶¼ºÜÂé·³£¬µã»÷µ½ÄǸöÎÞЧµÄSQL·þÎñÆ÷£¬Í¨³£¶¼ÊǑδÏìÓ¦’£¬ÄãÏëÓÃÓÒ¼üɾ³ýËü°É£¬Ò²ÊÇÒ»ÑùµÄδÏìÓ¦£¡µ±È»Å¼¶û¿ÉÒÔµã»÷ÓÒ¼üºó£¬²»ÒªÔÙ¶¯Êó±ê£¬µÈ´ýÄǸöδÏìÓ¦Ïûʧºó£¬¿ÉÒÔÔÚµ¯³öµÄÓÒ¼ü²Ëµ¥Éϵãɾ³ý£¡µ«ÊÇ£¬ÓÐÕâ¸öʱ¼äÒѾ¿ÉÒÔ˯һ¾õÁË£¡ËÓÐÕâ¸öÄÍÐÄ°¡£¡
׿±ÁË°É£¬Ïë×Å°ÑÕû¸öSQL Server×é¸øɾ³ýÁË£¬ÓÚÊÇÔÚSQL Server×éµÄ×éÃûÉϵãÓÒ¼ü,Ñ¡Ôñ"ɾ³ý",Ìáʾ"·þÎñÆ÷×éÖк¬ÓÐÖÁÉÙÒ»¸ö·þÎñÆ÷»ò×Ó×é,Òò´ËÎÞ·¨É¾³ý¸Ã×é". ¸ü¼±ÁË°É£¿Ð¡Ñù¾ÍÊDz»ÈÃÄãɾ³ý£¡
ÏëÏëËãÁË°É£¬É¾³ý²»Á˾Ͳ»É¾³ýÁË£¬¿ÉÊÇÄÄÌì¹ÜÀíÊý¾Ý¿âµÄʱºòÓÖ²»Ð¡Ðĵã»÷µ½ÄÇЩÎÞЧµÄSQL×¢²á£¬MDÓÖδÏìÓ¦ÀÏ°ëÌ죡
ËÑË÷ÁËϲŷ¢ÏÖÔÀ´¿ÉÒÔÔÚ×¢²á±íɾ³ý
ÔËÐÐCMD >> regedit >>
´ò¿ª×¢²á±íÕâ¸öλÖÃ:
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X\SQL Server
ÔÚÓÒ±ßɾ³ýÎÞЧµÄSQL×¢²áÃû!
Ïà¹ØÎĵµ£º
ÔÚVisual Studio 2008 ÖÐʹÓÃO/RÉè¼ÆÆ÷£º
µãÌí¼ÓÏîÄ¿£¬Ñ¡Ôñ´´½¨Linq to SQLÏîÄ¿£¬Ê¹Ó÷þÎñÆ÷×ÊÔ´¹ÜÀíÆ÷Á¬½ÓNorthwindÊý¾Ý¿â£¬½«CustomersºÍOrdersÁ½¸ö±íÍϵ½Éè¼Æ½çÃæÉÏ£¬ÏµÍ³»á×Ô¶¯´´½¨app.configºÍNorthwid.designer.cs,Ç°ÕßÊÇÅäÖÃÁ¬½ÓÊý¾Ý¿âµÄÁ¬½Ó×Ö´®£»ºóÕß»áÉú³ÉÒ»¸ö¼Ì³Ð×ÔDataContextµÄÀࣺNorthwindDataContext¡£
......
½ñÌ죬Óöµ½ÁËÕâÑùµÄÒ»¸öÀý×Ó£º
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. Ê¹Ó ......
----------------------------------------------------------------------
1¡¢SQLÊý¾Ý¿â»Ö¸´Ä£ÐÍ
----------------------------------------------------------------------
1£©ÍêÈ«»Ö¸´Ä£ÐÍ
-----------------
£¨1£©±¸·ÝʱҪ±¸·ÝÊý¾Ý¿âµÄÊý¾ÝÎļþºÍÈÕÖ¾Îļþ
£¨2£©»¹ÔʱʹÓÃÊý¾Ý¿âµÄ±¸·ÝµÄÊý¾ÝÎļþ¸±±¾ºÍÈ«²¿ÈÕÖ¾ÐÅ ......