Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÎÊÌ⣺ͨ¹ýsql ö¾Ùsqlserver ÉϽ¨Á¢µÄÁ´½Ó·þÎñÆ÷Áбí

ÎÊÌâÊÇÕâÑùµÄ£¬
Îҵı¾µØsqlserver 2000 ·þÎñÆ÷ÉÏ£¬½¨Á¢Á˶à¸öÔ¶³ÌÁ´½Ó·þÎñÆ÷£¬
ÇëÎÊ£¬ÎÒÈçºÎͨ¹ý sqlÓï¾ä£¬»òÕ߯äËûµÄ·½·¨Ã¶¾Ù ÕâЩÁ´½Ó·þÎñÆ÷ÄØ£¿£¨Í¨¹ýÆóÒµ¹ÜÀíÆ÷ÎÒÊÇÖªµÀµÄ£¬
ÎÒÒªµÄÊÇÄÜͨ¹ý±à³Ìö¾Ùµ½µÄ·½·¨£©
û×ö¹ý£¬²»¶®



--exec sp_addlinkedserver '×¢²áÃû','','SQLOLEDB','Ô¶³ÌÊý¾Ý¿âÃû'
--exec sp_addlinkedsrvlogin '×¢²áÃû','false',null,'Óû§Ãû','ÃÜÂë'
--go

ÊDz»ÊÇÕâ¸öÒâ˼£¿


Ïà¹ØÎÊ´ð£º

sql ²éѯ-¸üР×èÈû¡£¡£¡£¡££¿

Óöµ½µÄÏÖÏóÊÇ Í¬Ò»¸ö±íµÄquery»á×èÈûupdate

sql  query ºÍupdate ²Ù×÷ query»á×èÈûupdate²Ù×÷Âð

Ôõô½â¾ö

ÊDz»ÊÇʲôÉèÖò»¶Ô»¹ÊÇÔõµÄ


Èç¹û»áµÄ»°£¬ÄÇͬһ¸ö±íµÄƵ·±query and ......

ÇóSQLÒ»ÌõÓï¾äµÄ½â¾ö·½·¨

±ÈÈç ÎÒÓÐÒ»¸ö±í bumen

ÀïÃæ ÓÐÒ»¸öÁР quanxian
id  name  quanxian

1    a    001;002;003;
2    b    002;003;
3    ......

SQLÓï¾äÎÊÌâ

¿¼ÇÚ±ífty_grzl£¨mem_id  Ô±¹¤ID£¬adate  ÈÕÆÚ£¬type ÀàÐÍ£¬a1-a6  ´ò¿¨Ê±¼ä£¬jb »ù±¾¹¤Ê±£¬ot ¼Ó°à¹¤Ê±£¬cdd ³Ùµ½´ÎÊý£¬ztd ÔçÍË´ÎÊý£¬cdt ³Ùµ½Ê±¼ä£¬ztt ÔçÍËʱ¼ä£©
type£ºN Äê¼Ù£¬W Õý³£°à£¬J ......

ÓÐÈËÓùýsql server2005 ´´½¨·¢²¼Âð£¿

¾ÍÊÇÕ¹¿ªreplication ÓÒ¼üµ¥»÷ local Subscription ´´½¨·¢²¼£¬ ÓÐÈËÓùýÂ𣬳ɹ¦´´½¨·¢²¼µÄÓÐÂð£¿
Óùý£¬¿ÉÒԳɹ¦

ÒýÓÃ
Óùý£¬¿ÉÒԳɹ¦

Ã×ÓùýµÄ°ï¶¥

ÒýÓÃ
Óùý£¬¿ÉÒԳɹ¦

µÚÒ»²½ÎҾ͹ý² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ