ÓÐÈËÓùý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.È ......
SQL code: declare @cnt int select @cnt=count(1) from TableTest if(@cnt==0) insert into TableTest values(1,'abc') ¶ÔÓÚÕâÑùµÄÒ»¶Îsql²¢·¢Ö´ÐÐʱ,Ó¦¸ÃÓпÉÄܲåÈëÖظ´¼Ç¼ ²»ÖªµÀ´ó¼ÒÊÇÔõô· ......
ÐÕÃû ѧ¿Æ a ÓïÎÄ a Êýѧ b Ó¢Óï b ÕþÖÎ ÎÒÏëµÃµ½ a ÓïÎÄ£¬Êýѧ ......
ÇóÔÚһͬһ¸ö±íÀïÃæ a b 10 7 (a-b)=a ÔÚÔÀ´µÄ±íA¶Î¸üÐÂΪ3 ÏÈлл¸÷λÁË,°ï¸öæ SQL code: update a set a=a-b SQL code: -->Title:Generating test data -->Author ......
listidÊÇintÊý¾Ý declare @listid nvarchar(100) set @listid='(1,2,3,7,9,10)' select * from forums where listid in(@listid)ʱÌáʾÈçÏ´íÎó£º ÔÚ½« nvarchar Öµ '(1,2,3,7,9,10)' × ......