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

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

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

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

Ã×ÓùýµÄ°ï¶¥

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

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

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


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

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


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

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

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

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

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

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

ÄÇÒªÐ޸ijÉÊ²Ã´ÄØ£¿

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


Ïà¹ØÎÊ´ð£º

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

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

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

¼òµ¥µÄsqlÎÊÌâ

ÐÕÃû  ѧ¿Æ
a      ÓïÎÄ
a      Êýѧ
b      Ó¢Óï
b      ÕþÖÎ

ÎÒÏëµÃµ½  a    ÓïÎÄ£¬Êýѧ
  ......

SQLÓï¾äÎÊÌâ

create trigger TR_Delete_pm_WorkCard
on pm_WorkCard
for delete
as
if @@rowcount=0 return
begin tran
  update pm_PlanEntry
  set FDispatchQty=t4.FDispatchQty - t1.FDispat ......

sqlÓï¾äÎÊÌâ

ÓÐÒ»¸ö±íAA
name  tj
1    a
1    b
1    c
2    a
2    d
3    b
ÒªÇóµ±tj×ֶεÄÖµ¼ÈµÈÓÚaÓÖµÈÓÚcʱ£¨tj = ¡®a¡ ......

ÇóSQL¡«¡«¡«¡«¡«

×ÜÊý±í
×Ö¶Î num,freq
numÊÇËùÊôÆÚµÄ×ÜÊý£¬freqÊǼǼ¸ÃÊýÖµËùÊôÄÄÒ»ÆÚµÄ


ÇøÓò±í
×Ö¶Î area_name,tot,freq
ÇøÓòÃû³Æ£¬¸ÃÇøÓòµÄ×ÜÊý£¬ËùÊôÆÚ

Á½ÕÅ±í¿¿freq¹ØÁª£¬ÇÒ²»ÊÇ×ÔÔö×ֶΣ¬²»ÊÇÖ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ