ÓÐÈËÓùýsql server2005 ´´½¨·¢²¼Âð£¿
¾ÍÊÇÕ¹¿ªreplication ÓÒ¼üµ¥»÷ local Subscription ´´½¨·¢²¼£¬ ÓÐÈËÓùýÂ𣬳ɹ¦´´½¨·¢²¼µÄÓÐÂð£¿
Óùý£¬¿ÉÒԳɹ¦ÒýÓà Óùý£¬¿ÉÒԳɹ¦ Ã×ÓùýµÄ°ï¶¥ÒýÓà Óùý£¬¿ÉÒԳɹ¦ µÚÒ»²½ÎҾ͹ý²»È¥£¬ÒªÅäÖÃʲôÂð£¿ËüÌáʾÎÒûÓÐȨÏÞ»òÊÇ·þÎñÆ÷ûÓз¢²¼ÕâÊÇΪʲô£¿ ÏÈ´´½¨·¢²¼ºÍ·Ö·¢·þÎñÆ÷,ÔÙ´´½¨·¢²¼,×îºóÌí¼Ó¶©ÔÄ¡£ÒýÓà ÒýÓà 3 Â¥ hupo11520 µÄ»Ø¸´: ÒýÓà 1 Â¥ xiequan2 µÄ»Ø¸´: Óùý£¬¿ÉÒԳɹ¦ µÚÒ»²½ÎҾ͹ý²»È¥£¬ÒªÅäÖÃʲôÂð£¿ËüÌáʾÎÒûÓÐȨÏÞ»òÊÇ·þÎñÆ÷ûÓз¢²¼ÕâÊÇΪʲô£¿ ÄãµÄsql serverÓÐÎÊÌâ°É£¬ÎҵĵÚÒ»²½Ã»ÓÐÎÊÌ⣬¶øÇÒҲûÓÐ×÷Ê²Ã´ÌØ±ðÉèÖà ÄãÓÐsqlserver 2005 µÄÏÂÔØµØÖ·Â𣿠MSSQLserverºÍSqlserveragent·þÎñ ²»ÄÜÓÃĬÈϵı¾µØÏµÍ³ÕÊ»§localÀ´Æô¶¯£¬ÐèÒªÐ޸ġ£ Õâ¸öÒ»¶¨Òª×¢Òâ¡£ÒýÓà MSSQLserverºÍSqlserveragent·þÎñ ²»ÄÜÓÃĬÈϵı¾µØÏµÍ³ÕÊ»§localÀ´Æô¶¯£¬ÐèÒªÐ޸ġ£ Õâ¸öÒ»¶¨Òª×¢Òâ¡£ ÄÇÒªÐ޸ijÉÊ²Ã´ÄØ£¿ ÎÊÌâ½â¾öÁË£¬Ð»Ð»´ó¼Ò¡£ÊÇsqlÓÐÎÊÌâ¡£
Ïà¹ØÎÊ´ð£º
ÓÐÈý¸ö±íÒ»¸öÊDzɹºµ¥¸ñʽÈçÏ Èë¿âµ¥±í£º Èë¿âµ¥ºÅ ²úÆ· Öʼì±àºÅ Èë¿âÊýÁ¿ 001 Æ·ÖÖ1&n ......
ÐÕÃû ѧ¿Æ a ÓïÎÄ a Êýѧ b Ó¢Óï b ÕþÖÎ ÎÒÏëµÃµ½ a ÓïÎÄ£¬Êýѧ ......
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 ......
ÓÐÒ»¸ö±íAA name tj 1 a 1 b 1 c 2 a 2 d 3 b ÒªÇóµ±tj×ֶεÄÖµ¼ÈµÈÓÚaÓÖµÈÓÚcʱ£¨tj = ¡®a¡ ......
×ÜÊý±í ×Ö¶Î num,freq numÊÇËùÊôÆÚµÄ×ÜÊý£¬freqÊǼǼ¸ÃÊýÖµËùÊôÄÄÒ»ÆÚµÄ ÇøÓò±í ×Ö¶Î area_name,tot,freq ÇøÓòÃû³Æ£¬¸ÃÇøÓòµÄ×ÜÊý£¬ËùÊôÆÚ Á½ÕÅ±í¿¿freq¹ØÁª£¬ÇÒ²»ÊÇ×ÔÔö×ֶΣ¬²»ÊÇÖ ......