ÓÐÈËÓùýsql server2005 ´´½¨·¢²¼Âð£¿
¾ÍÊÇÕ¹¿ªreplication ÓÒ¼üµ¥»÷ local Subscription ´´½¨·¢²¼£¬ ÓÐÈËÓùýÂ𣬳ɹ¦´´½¨·¢²¼µÄÓÐÂð£¿
Óùý£¬¿ÉÒԳɹ¦ÒýÓà Óùý£¬¿ÉÒԳɹ¦ Ã×ÓùýµÄ°ï¶¥ÒýÓà Óùý£¬¿ÉÒԳɹ¦ µÚÒ»²½ÎҾ͹ý²»È¥£¬ÒªÅäÖÃʲôÂð£¿ËüÌáʾÎÒûÓÐȨÏÞ»òÊÇ·þÎñÆ÷ûÓз¢²¼ÕâÊÇΪʲô£¿ ÏÈ´´½¨·¢²¼ºÍ·Ö·¢·þÎñÆ÷,ÔÙ´´½¨·¢²¼,×îºóÌí¼Ó¶©ÔÄ¡£ÒýÓà ÒýÓà 3 Â¥ hupo11520 µÄ»Ø¸´: ÒýÓà 1 Â¥ xiequan2 µÄ»Ø¸´: Óùý£¬¿ÉÒԳɹ¦ µÚÒ»²½ÎҾ͹ý²»È¥£¬ÒªÅäÖÃʲôÂð£¿ËüÌáʾÎÒûÓÐȨÏÞ»òÊÇ·þÎñÆ÷ûÓз¢²¼ÕâÊÇΪʲô£¿ ÄãµÄsql serverÓÐÎÊÌâ°É£¬ÎҵĵÚÒ»²½Ã»ÓÐÎÊÌ⣬¶øÇÒҲûÓÐ×÷ʲôÌرðÉèÖà ÄãÓÐsqlserver 2005 µÄÏÂÔصØÖ·Â𣿠MSSQLserverºÍSqlserveragent·þÎñ ²»ÄÜÓÃĬÈϵı¾µØϵͳÕÊ»§localÀ´Æô¶¯£¬ÐèÒªÐ޸ġ£ Õâ¸öÒ»¶¨Òª×¢Òâ¡£ÒýÓà MSSQLserverºÍSqlserveragent·þÎñ ²»ÄÜÓÃĬÈϵı¾µØϵͳÕÊ»§localÀ´Æô¶¯£¬ÐèÒªÐ޸ġ£ Õâ¸öÒ»¶¨Òª×¢Òâ¡£ ÄÇÒªÐ޸ijÉʲôÄØ£¿ ÎÊÌâ½â¾öÁË£¬Ð»Ð»´ó¼Ò¡£ÊÇsqlÓÐÎÊÌâ¡£
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......
ÓÐÈý¸ö±íÒ»¸öÊDzɹºµ¥¸ñʽÈçÏ Èë¿âµ¥±í£º Èë¿âµ¥ºÅ ²úÆ· Öʼì±àºÅ Èë¿âÊýÁ¿ 001 Æ·ÖÖ1&n ......
SQL code: declare @cnt int select @cnt=count(1) from TableTest if(@cnt==0) insert into TableTest values(1,'abc') ¶ÔÓÚÕâÑùµÄÒ»¶Îsql²¢·¢Ö´ÐÐʱ,Ó¦¸ÃÓпÉÄܲåÈëÖظ´¼Ç¼ ²»ÖªµÀ´ó¼ÒÊÇÔõô· ......
Óöµ½µÄÏÖÏóÊÇ Í¬Ò»¸ö±íµÄquery»á×èÈûupdate sql query ºÍupdate ²Ù×÷ query»á×èÈûupdate²Ù×÷Âð Ôõô½â¾ö ÊDz»ÊÇʲôÉèÖò»¶Ô»¹ÊÇÔõµÄ Èç¹û»áµÄ»°£¬ÄÇͬһ¸ö±íµÄƵ·±query and ......
±ÈÈç ÎÒÓÐÒ»¸ö±í bumen ÀïÃæ ÓÐÒ»¸öÁÐ quanxian id name quanxian 1 a 001;002;003; 2 b 002;003; 3 ......