ÓÐÈËÓùýsql server2005 ´´½¨·¢²¼Âð£¿
¾ÍÊÇÕ¹¿ªreplication ÓÒ¼üµ¥»÷ local Subscription ´´½¨·¢²¼£¬ ÓÐÈËÓùýÂ𣬳ɹ¦´´½¨·¢²¼µÄÓÐÂð£¿
Óùý£¬¿ÉÒԳɹ¦ÒýÓà Óùý£¬¿ÉÒԳɹ¦ Ã×ÓùýµÄ°ï¶¥ÒýÓà Óùý£¬¿ÉÒԳɹ¦ µÚÒ»²½ÎҾ͹ý²»È¥£¬ÒªÅäÖÃʲôÂð£¿ËüÌáʾÎÒûÓÐȨÏÞ»òÊÇ·þÎñÆ÷ûÓз¢²¼ÕâÊÇΪʲô£¿ ÏÈ´´½¨·¢²¼ºÍ·Ö·¢·þÎñÆ÷,ÔÙ´´½¨·¢²¼,×îºóÌí¼Ó¶©ÔÄ¡£ÒýÓà ÒýÓà 3 Â¥ hupo11520 µÄ»Ø¸´: ÒýÓà 1 Â¥ xiequan2 µÄ»Ø¸´: Óùý£¬¿ÉÒԳɹ¦ µÚÒ»²½ÎҾ͹ý²»È¥£¬ÒªÅäÖÃʲôÂð£¿ËüÌáʾÎÒûÓÐȨÏÞ»òÊÇ·þÎñÆ÷ûÓз¢²¼ÕâÊÇΪʲô£¿ ÄãµÄsql serverÓÐÎÊÌâ°É£¬ÎҵĵÚÒ»²½Ã»ÓÐÎÊÌ⣬¶øÇÒҲûÓÐ×÷Ê²Ã´ÌØ±ðÉèÖà ÄãÓÐsqlserver 2005 µÄÏÂÔØµØÖ·Â𣿠MSSQLserverºÍSqlserveragent·þÎñ ²»ÄÜÓÃĬÈϵı¾µØÏµÍ³ÕÊ»§localÀ´Æô¶¯£¬ÐèÒªÐ޸ġ£ Õâ¸öÒ»¶¨Òª×¢Òâ¡£ÒýÓà MSSQLserverºÍSqlserveragent·þÎñ ²»ÄÜÓÃĬÈϵı¾µØÏµÍ³ÕÊ»§localÀ´Æô¶¯£¬ÐèÒªÐ޸ġ£ Õâ¸öÒ»¶¨Òª×¢Òâ¡£ ÄÇÒªÐ޸ijÉÊ²Ã´ÄØ£¿ ÎÊÌâ½â¾öÁË£¬Ð»Ð»´ó¼Ò¡£ÊÇsqlÓÐÎÊÌâ¡£
Ïà¹ØÎÊ´ð£º
ÓÐÁ½¸ö±í¡£·Ö±ð¶¼ÓÐIDÖ÷¼ü¡£A±íµÄIDºÍB±íµÄIDÊǶÔÓ¦µÄ£¬¾ÍÊÇA±í¼¸¸öID£¬B±í¾Í¼¸¸öID¡£A±íµÄIDÊÇʲô,B±íµÄID¾ÍÊÇʲô¡£ ¿ÉÊÇÏÖÔÚA±íµÄID±ÈB±íµÄ¶àÁË¡£ ÎÒÏÖÔÚÏëÒª°ÑB±íÖÐÉٵIJ¿·Ö¸ø²¹ÆëÁË¡£Õâ¸ö²åÈëÓ¦¸ÃÔõôд ......
¿Í»§±í£º ¿Í»§±àºÅ ¿Í»§ÏúÊÛ×ܶî aa 200 bb 300 cc ......
ÇëÎʸßÊÖ2005µÄ±ê×¼°æÊÇ·ñ¿ÉÒÔÔ¶³ÌÁ¬½Ó£¬Èç¹û¿ÉÒÔ£¬Ó¦¸ÃÔõôÉèÖã¬ÎÒ°´ÕÕ Express°æµÄÉèÖÃÁË£¬²»ÐС£¡£ ¿ÉÒÔ ¿ÉÒÔ ²»ÖªµÀÄãÏëÔõôԶ³ÌÁ´½Ó Ö±½ÓÔÚ¿Í»§¶ËµÇ¼¡£¡£ °´ÕÕ5Â¥µÄ×öÁË È»ºóÔÚ¿Í»§¶ËдÁ¬½Ó× ......
create trigger TR_Delete_pm_WorkCard on pm_WorkCard for delete as if @@rowcount=0 return begin tran update pm_PlanEntry set FDispatchQty=t4.FDispatchQty - t1.FDispat ......