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

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

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

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

Ã×ÓùýµÄ°ï¶¥

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

µÚÒ»²½ÎҾ͹ý²»È¥£¬ÒªÅäÖÃʲôÂð£¿ËüÌáʾÎÒûÓÐȨÏÞ»òÊÇ·þÎñÆ÷ûÓз¢²¼ÕâÊÇΪʲô£¿

ÏÈ´´½¨·¢²¼ºÍ·Ö·¢·þÎñÆ÷,ÔÙ´´½¨·¢²¼,×îºóÌí¼Ó¶©ÔÄ¡£


ÒýÓÃ
ÒýÓà 3 Â¥ hupo11520 µÄ»Ø¸´:
ÒýÓà 1 Â¥ xiequan2 µÄ»Ø¸´:
  Óùý£¬¿ÉÒԳɹ¦

  µÚÒ»²½ÎҾ͹ý²»È¥£¬ÒªÅäÖÃʲôÂð£¿ËüÌáʾÎÒûÓÐȨÏÞ»òÊÇ·þÎñÆ÷ûÓз¢²¼ÕâÊÇΪʲô£¿


ÄãµÄsql serverÓÐÎÊÌâ°É£¬ÎҵĵÚÒ»²½Ã»ÓÐÎÊÌ⣬¶øÇÒҲûÓÐ×÷ʲôÌرðÉèÖÃ

ÄãÓÐsqlserver 2005 µÄÏÂÔصØÖ·Âð£¿

MSSQLserverºÍSqlserveragent·þÎñ  ²»ÄÜÓÃĬÈϵı¾µØϵͳÕÊ»§localÀ´Æô¶¯£¬ÐèÒªÐ޸ġ£

Õâ¸öÒ»¶¨Òª×¢Òâ¡£

ÒýÓÃ
MSSQLserverºÍSqlserveragent·þÎñ  ²»ÄÜÓÃĬÈϵı¾µØϵͳÕÊ»§localÀ´Æô¶¯£¬ÐèÒªÐ޸ġ£

Õâ¸öÒ»¶¨Òª×¢Òâ¡£

ÄÇÒªÐ޸ijÉʲôÄØ£¿

ÎÊÌâ½â¾öÁË£¬Ð»Ð»´ó¼Ò¡£ÊÇsqlÓÐÎÊÌâ¡£


Ïà¹ØÎÊ´ð£º

ÇóSQL£¿

´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e 
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......

Çó½ÌÒ»¸öSql²éѯÎÊÌâ¡£

ÓÐÈý¸ö±íÒ»¸öÊDzɹºµ¥¸ñʽÈçÏÂ
Èë¿âµ¥±í£º

Èë¿âµ¥ºÅ      ²úÆ·        Öʼì±àºÅ      Èë¿âÊýÁ¿
001          Æ·ÖÖ1&n ......

Çë½Ìsql¸ßÊÖ,¹ØÓÚms-sqlserverËø»úÖÆ

SQL code:

declare @cnt int
select @cnt=count(1) from TableTest
if(@cnt==0)
insert into TableTest values(1,'abc')


¶ÔÓÚÕâÑùµÄÒ»¶Îsql²¢·¢Ö´ÐÐʱ,Ó¦¸ÃÓпÉÄܲåÈëÖظ´¼Ç¼
²»ÖªµÀ´ó¼ÒÊÇÔõô· ......

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    ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ