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

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

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

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

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

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

    falseIDµÄÖµ1¸üÐÂΪxʱ£¬±í2£¨tb_small£©µÄfalseIDËùÓÐΪ1Öµ¶¼×Ô¶¯±ä³Éx£¬¼´Ç°Èý¸ö1½«»á±ä³ÉÈý¸öx£»

    falseIDµÄÖµ2¸üÐÂΪyʱ£¬±í2£¨tb_small£©µÄfalseIDËùÓÐ2µÄÖµ¶¼×Ô¶¯±äΪy£¬¼´ÖмäÈý¸ö2±ä³ÉÈý¸öy£»

    falseIDµÄÖµ3¸üÐÂΪzʱ£¬±í2£¨tb_small£©µÄfalseIDËùÓÐ3µÄÖµ¶¼×Ô¶¯±äΪz£¬¼´×îºóÈý¸ö3±ä³ÉÈý¸öz£»

¾ßÌåµÄ´¥·¢Æ÷Ó¦¸ÃÔõôд£¿£¿Çë´óϺÃǰï°ï棡£¡£¡£¡£¡£¡

ºÃÏóºÍÉÏÎçÄãÎʵÄÄǸö²î²»¶à,Èç¹ûÄãµÄÊý¾ÝÊÇÒÔ´®µÄÐÎʽ´æÔھͺÜÂé·³ÁË.°ï¶¥.


Ïà¹ØÎÊ´ð£º

java»ñµÃmssqlÊý¾Ý¼¯µÄÎÊÌâ

ÓÉÓÚ×î½üҪдһ¸ö·ÖÒ³µÄ³ÌÐò£¬ÔÚÍøÉÏÕÒÁ˸ö´æ´¢¹ý³Ì£»
  create  procedure add_pp_SqlPager
  @sqlstr nvarchar(4000),                --²éѯ×Ö·û ......

ÕÐÆ¸MsSQL DBA - ÉϺ£

ÓÐÒâÕßÇëÁªÏµyushan-33@hotmail.com / 18821146311

Microsoft SQL Administrator

Job Description:

A detail oriented Microsoft SQL Administratorwith excellent problem solving, analyti ......

ƽ°²Ò¹¸øÃ»ÊÕµ½ÀñÎïµÄGG &&MM ËÍ·Ö -MSSQL°æ

ƽ°²Ò¹¸øÃ»ÊÕµ½ÀñÎïµÄGG &&MM ÎÒÀ´ËÍÀñÎïÀ²¡£
ÊÕµ½ÀñÎïµÄ¾Í±ð½Ó·ÖÁË£¡ÒªÊǽӲ»µ½°Ñ×Ô¼ºµÄ³ôÍà×ÓÄóöÀ´£¬µÈÊ¥µ®ÀÏÈËÍíÉÏËÍÄã°É£¡
SF

bd

sf

À´jfµÄ

²»´©Íà×Ó

JAVA php JS MYSQL C# °æ¶¼·¢Í ......

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

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