ÓÐÈËÓùýsql server2005 ´´½¨·¢²¼Âð£¿
¾ÍÊÇÕ¹¿ªreplication ÓÒ¼üµ¥»÷ local Subscription ´´½¨·¢²¼£¬ ÓÐÈËÓùýÂ𣬳ɹ¦´´½¨·¢²¼µÄÓÐÂð£¿
Óùý£¬¿ÉÒԳɹ¦
Ã×ÓùýµÄ°ï¶¥
µÚÒ»²½ÎҾ͹ý²»È¥£¬ÒªÅäÖÃʲôÂð£¿ËüÌáʾÎÒûÓÐȨÏÞ»òÊÇ·þÎñÆ÷ûÓз¢²¼ÕâÊÇΪʲô£¿
ÏÈ´´½¨·¢²¼ºÍ·Ö·¢·þÎñÆ÷,ÔÙ´´½¨·¢²¼,×îºóÌí¼Ó¶©ÔÄ¡£
ÄãÓÐsqlserver 2005 µÄÏÂÔØµØÖ·Âð£¿
MSSQLserverºÍSqlserveragent·þÎñ ²»ÄÜÓÃĬÈϵı¾µØÏµÍ³ÕÊ»§localÀ´Æô¶¯£¬ÐèÒªÐ޸ġ£
Õâ¸öÒ»¶¨Òª×¢Òâ¡£
ÄÇÒªÐ޸ijÉÊ²Ã´ÄØ£¿
ÎÊÌâ½â¾öÁË£¬Ð»Ð»´ó¼Ò¡£ÊÇsqlÓÐÎÊÌâ¡£
Ïà¹ØÎÊ´ð£º
sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001
ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......
ÓÐÒ»¸ö±íAA
name tj
1 a
1 b
1 c
2 a
2 d
3 b
ÒªÇóµ±tj×ֶεÄÖµ¼ÈµÈÓÚaÓÖµÈÓÚcʱ£¨tj = ¡®a¡ ......
µã»÷¡°·þÎñ¹ÜÀíÆ÷¡±£¬µã»÷¡°¿ªÊ¼/¼ÌÐø¡±£¬×ÜÊÇÏÔʾ¡°ÓÉÓڵǼʧ°Ü¶øÆô¶¯·þÎñ¡±£¬È»ºóÔٴγö´í£¬²»Äܹ»½øÈ룬Ҳ²»Äܹ»²é¿´ÊôÐÔ£¬ÇëÎÊ´ó¼Ò¸ÃÔõô°ì£¿
ÎÒÊDzſªÊ¼Ñ§Ï°Êý¾Ý¿â£¬ÇëÎÊ´ó¼ÒÓÐûÓÐʲôºÃһЩµÄ½¨Òé»òÕ ......
ÏÖÔÚÐèÒªÔÚSQL ServerʵÏÖ¶¨Ê±±¨±íÊä³öµÄ¹¦ÄÜ£¬
ÀýÈçÔÚÿÌìµÄ12µãÉú³Éµ±ÌìµÄ±¨±í£¬²¢Êä³öµ½Excel»òÆäËü¸ñʽµÄÎļþÖС£
ÎÒµ÷²éÁËһϣ¬ËµSQL Server ±¨±í·þÎñÓÐÕâ¸ö¹¦ÄÜ£¬µ«ÊÇûÓùý±¨±í·þÎñ£¬²»ÖªÈçºÎʵÏÖ£¬Çë ......