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

Âé·³´óϺÃǰïæдһ¸öMSSQLµÄ´¥·¢Æ÷£¬¼±ÓÃ

±íµÄ½á¹¹ÈçÏ£º

±í1£ºtb_big
×ֶΣºfalseIDÖµ£º1£¬2
×ֶΣºbigtype Öµ£ºA£¬B£¨ÓëfalseIDµÄÖµµÄλÖÃÒ»Ò»¶ÔÓ¦£¬¼´1¶ÔÓ¦A£¬2¶ÔÓ¦B£©

±í2£ºtb_small
×ֶΣºfalseID£¨Óëtb_bigµÄfalseID¹ØÁªµÄ£© Öµ£º1£¬1£¬1£¬2£¬2£¬2
×ֶΣºsmalltype Öµ£ºa1£¬a2£¬a3£¬b1£¬b2£¬b3£¨1¶ÔÓ¦a1£¬1¶ÔÓ¦a2£¬1¶ÔÓ¦a3£¬2¶ÔÓ¦b1£¬ÀàÍÆÏÂÈ¥£©

ÎÒÏëʵÏֵŦÄÜÈçÏ£º
ÎÒÏëÔÚ±í1£¨tb_big£©ÄÚн¨Ò»¸ö´¥·¢Æ÷£¬µ±ÎÒ½«tb_bigÖеÄ

  ²½ÖèÒ»£ºtb_big.falseIDµÄÖµ1¸üÐÂΪ2ʱ£¬±í2£¨tb_small£©µÄfalseIDËùÓÐΪ1Öµ¶¼×Ô¶¯±ä³É2£¬¼´Ç°Èý¸ö1½«»á±ä³ÉÈý¸ö2£»
  ¡¾×¢Ò⣺²½ÖèÒ»½áÊøºó£¬tb_smallÀïÃæµÄfalseIDÓÐÁù¸ö2ÁË¡£¡¿

  ²½Öè¶þ£ºtb_big.falseIDµÄÖµ2¸üÐÂΪ1ʱ£¬±í2£¨tb_small£©µÄfalseID¡¾Ô­À´ÖмäµÄÈý¸ö2¡¿µÄÖµ¶¼×Ô¶¯±äΪ1£¬¼´¡¾Ô­À´ÖмäÈý¸ö2¡¿±ä³ÉÈý¸ö1£»£¨×¢Ò⣺ÕâÒ»²½¡¾ÎÒ²»Ïë¡¿½«¾­¹ý²½ÖèÒ»±ä³ÉµÄ¡¾Áù¸ö2¡¿¶¼±ä³É1£¬¶øÊǽ«¡¾Ô­À´µÄÖмäµÄÈý¸ö2¡¿±ä³É1£©
 
  ÇëÎÊÕâÑùµÄ´¥·¢Æ÷Ó¦¸ÃÔõôд£¿£¿°ï°ïæ¿ÉÒÔÂð£¬ÉϽ»×÷Æ·µÄʱ¼ä¿ìµ½ÁË£¬ÖÔÐĸÐл£¡£¡£¡£¡
²½Öè¶þû·¨ÊµÏÖ°¡£¡
{{


Ïà¹ØÎÊ´ð£º

vc²Ù×÷mssqlһСÎÊÌâ

ÏÖÔÚÁ¬µÄÒ»Ô¶³Ìmssql£¬Ã¿´Î²éѯ±È½ÏÂý£¬ÏÖÔÚÏëһϰÑËùÓмǼ²éѯ³öÀ´ÓÃÊý¾Ý¼¯±£´æÆðÀ´£¬È»ºóÕë¶ÔÊý¾Ý¼¯Ôٴβéѯɸѡ¡£
ÏÖÔÚÎÊÏÂÄǸöÊý¾Ý¼¯ÈçºÎ±£´æ²éѯ¼Ç¼£¬¶øÔٴβéѯ£¬¶àлÁË¡£
¿ÉÒÔ°ÑÊý¾Ý¼¯ÖеÄÊý¾Ý·Åµ½ÄÚ´ ......

MSSQL 2008 °²×°ÎÊÌâ

°²×°¹ý³Ìʱû³öÏÖ´íÎóÌáʾ¡£ Ò»Ö±µ½½áÊø£¬Ôò˵MSSQL û°²×°³É¹¦

Summary.txt ÄÚÈÝÈçÏ£º

Overall summary:
  Final result:                  ......

MSSQLÈçºÎ²åÈë²»ÏàͬµÄ¼Ç¼ - .NET¼¼Êõ / ASP.NET

ÈçÌ⣬Óû§×¢²áʱ£¬Óû§ÃûÊDz»ÄÜÖØ¸´µÄ£¬ÈçºÎÅжϲåÈëµÄ¼Ç¼²»Öظ´ÄØ£¿
Çë¿´Çå³þÎÒµÄÌâÄ¿£¬²»Òª´ÓÍøÉϳ­Ò»Ð©´ð°¸¹ýÀ´£¬ÍøÉϺܶàÈËдµÄÏÈselectÔÙinsertµÄ¶¼ÊÇϹ³¶£¬Ñ¹¸ù¾Íû¿¼Âǵ½²¢·¢ÐÔÎÊÌ⣬ÎÒÏÖÔÚ²»Ïë¼ÓÉÏÐòÁл¯ ......

ÔÚMSSQLÖÐдһ¸ö´¥·¢Æ÷,¼±ÓÃ

±íµÄ½á¹¹ÈçÏ£º

±í1£ºtb_big
×ֶΣºfalseIDÖµ£º1£¬2£¬3
×ֶΣºbigtype Öµ£ºA£¬B£¬C£¨ÓëfalseIDµÄÖµµÄλÖÃÒ»Ò»¶ÔÓ¦£¬¼´1¶ÔÓ¦A£¬2¶ÔÓ¦B£©

±í2£ºtb_small
×ֶΣºfalseID£¨Óëtb_bigµÄfalseID ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ