¹ØÓÚMSSQLÊý¾Ý¿â½ÇÉ«ÊôÐÔȨÏÞÑ¡ÔñÎÊÌâ
ÇëÎÊÔÚ¸³ÓèÊý¾Ý¿â½Çɫʱ£¬»áÓÐÕâ¸öȨÏÞÑ¡ÔñÃæ°å£¬Í¨³£MSSQLÀïÃæµÄ¿ò¿ò¶¼ÊÇ¿Õ×Å£¬Õâ¸öȨÏÞÑ¡Ôñ¿òÓÐÈýÖÖ״̬£¬
1¡¢¿Õ×Å
2¡¢Ñ¡ÖУ¬ÂÌÉ«µÄ¹´
3¡¢È¡Ïû£¬ºìÉ«µÄ²æ²æ¡£
Ñ¡ÖкÜÈÝÒ×Àí½â£¬µ«Èç¹û¶¼²»Ñ¡Ôñ£¬ÄÇô¿Õ×ŵĿò¿òÊDZíʾʲô£¿ÊǵÈͬÓÚÈ¡Ïû£¬»¹ÊÇÑ¡ÖУ¿»¹ÊÇĬÈÏÓÐÕâ¸öȨÏÞ£¿
лл£¡
È¡Ïû
¿ÕןÍXXÓ¦¸ÃÊÇÒ»¸öЧ¹û¡£
¿ÉÒÔ²»XX ¿Õ×ÅÒ»Ñù
È¡Ïû
ºÃÏñÒ²²»ÊÇ¡°È¡Ïû¡±µÄº¬Ò壬±ÈÈ磺
Ñ¡ÔñÒ»¸öÊý¾Ý¿â——Óû§——Ñ¡ÖÐÒ»¸öÊý¾Ý¿âËùÓÐÕßµÄÓû§Ãû——ÊôÐÔ——´ò¿ª¡°Êý¾Ý¿âÓû§ÊôÐÔÃæ°å¡±——Ñ¡Ôñdb_owner£¬ÔÙµã»÷¡°È¨ÏÞ¡±¡£
ÔÚµ¯³öµÄÓû§ÊôÐÔȨÏÞÃæ°åÉÏ£¬°ÑÆäÖеÄȨÏÞ¿ò½Óµ½ÏÂÃæÓû§±íÉÏ£¬ÆäÖеĿò¿òÒ²¶¼ÊÇ¿Õ×Å£¬µ«Õâ¸öÓû§¿ÉÒÔÖ´ÐÐselect £¬update , insert µÈÊÂÎñ£¬Õâ˵Ã÷¿ò¿òÈç¹ûÊÇ¿Õ×Å£¬ºÃÏñÊÇĬÈÏÓÐÕâЩȨÏÞ¡£
¸ãÔÎÁË¡£
¸Ðл¥ÉÏ£¬Ð»Ð»£¡
Ïà¹ØÎÊ´ð£º
2005ºó£¬MSSQLÔö¼ÓÁËÐÂÌØÐÔ¡£
½ñÌìÉÔ´øÁ˼¸ÑÛ£¬ÈçÊý¾Ý¿â´¥·¢Æ÷£¬¼Ü¹¹£¬Êý¾Ý¿â´¥·¢Æ÷£¬·þÎñÆ÷´¥·¢Æ÷µÈ¡£ºÜ¶àÊÇеÄÄÚÈÝ£¬ÓÐЩÊǸÅÄî·¢ÉúÁËһЩ±ä»¯¡£
ÓÐЩSQLµÃµ½ÁËÔöÇ¿¡£
Èçfromºó¿ÉÒÔ¸ú²ÉÑùÓï¾ä£¬½»²æ±í£¬ ......
»áÔ±ID£ºws_hgo
ÉêÇë°æÃæ£ºSQL ServerÒÉÄÑÎÊÌâ
ÉêÇë°æÖ÷ÀíÓÉ£ºÏ£ÍûÔÚCSDN¾¡¿ÉÄܵİïÖú´ó¼Ò,Ï£ÍûÄܹ»ºÍ´ó¼ÒÒ»ÆðÌá¸ßMSSQL¼¼Êõ
ƽ¾ùÉÏÍøÊ±¼ä(Сʱ/Ìì)£º>12Сʱ
ÊÇ·ñµ£Èιý±¾ÉçÇø»òÕ߯äËûÉçÇøÏà¹ØÖ ......
SQL code:
For Ls_desc IN (Select Di_ename ,Di_Pcs,Di_Unitprice
from T_BO_DeclareInvoice Di
WHERE bs_code = as_bs_code)
LOOP
IF Ls_desc.Di_ename IS ......
±ÈÈç
Ò»¸öÊÇÓû§Áбí
UserID
1
2
3
4
Ò»¸öÊÇ´ÎÊýÁбí(ÿÌì·ÃÎÊÒ»´ÎNum+1)
UserID Day Num
1 2009-09-22 10
2 2009-09-22 20
4 2009-09-22 8
......
ÈçÌ⣬²éѯÓï¾ä²ÎÊýÓ¦¸ÃÔõôд°¡£¿
¸ø²ÎÊý¸³Öµ¡¡ÔõôŪ°¡£¿
with Query do begin
tempParam=parameters.addparameter;
tempParam.name='@begindate';
tempParam.Da ......