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

¹ØÓÚMSSQLÊý¾Ý¿â½ÇÉ«ÊôÐÔȨÏÞÑ¡ÔñÎÊÌâ



ÇëÎÊÔÚ¸³ÓèÊý¾Ý¿â½Çɫʱ£¬»áÓÐÕâ¸öȨÏÞÑ¡ÔñÃæ°å£¬Í¨³£MSSQLÀïÃæµÄ¿ò¿ò¶¼ÊÇ¿Õ×Å£¬Õâ¸öȨÏÞÑ¡Ôñ¿òÓÐÈýÖÖ״̬£¬
1¡¢¿Õ×Å
2¡¢Ñ¡ÖУ¬ÂÌÉ«µÄ¹´
3¡¢È¡Ïû£¬ºìÉ«µÄ²æ²æ¡£

Ñ¡ÖкÜÈÝÒ×Àí½â£¬µ«Èç¹û¶¼²»Ñ¡Ôñ£¬ÄÇô¿Õ×ŵĿò¿òÊDZíʾʲô£¿ÊǵÈͬÓÚÈ¡Ïû£¬»¹ÊÇÑ¡ÖУ¿»¹ÊÇĬÈÏÓÐÕâ¸öȨÏÞ£¿

лл£¡
È¡Ïû

¿ÕןÍXXÓ¦¸ÃÊÇÒ»¸öЧ¹û¡£

¿ÉÒÔ²»XX ¿Õ×ÅÒ»Ñù

È¡Ïû

ºÃÏñÒ²²»ÊÇ¡°È¡Ïû¡±µÄº¬Ò壬±ÈÈ磺
Ñ¡ÔñÒ»¸öÊý¾Ý¿â——Óû§——Ñ¡ÖÐÒ»¸öÊý¾Ý¿âËùÓÐÕßµÄÓû§Ãû——ÊôÐÔ——´ò¿ª¡°Êý¾Ý¿âÓû§ÊôÐÔÃæ°å¡±——Ñ¡Ôñdb_owner£¬ÔÙµã»÷¡°È¨ÏÞ¡±¡£
ÔÚµ¯³öµÄÓû§ÊôÐÔȨÏÞÃæ°åÉÏ£¬°ÑÆäÖеÄȨÏÞ¿ò½Óµ½ÏÂÃæÓû§±íÉÏ£¬ÆäÖеĿò¿òÒ²¶¼ÊÇ¿Õ×Å£¬µ«Õâ¸öÓû§¿ÉÒÔÖ´ÐÐselect £¬update , insert µÈÊÂÎñ£¬Õâ˵Ã÷¿ò¿òÈç¹ûÊÇ¿Õ×Å£¬ºÃÏñÊÇĬÈÏÓÐÕâЩȨÏÞ¡£

¸ãÔÎÁË¡£


¸Ðл¥ÉÏ£¬Ð»Ð»£¡


Ïà¹ØÎÊ´ð£º

MSSQL ÐÂÌØÐÔ

2005ºó£¬MSSQLÔö¼ÓÁËÐÂÌØÐÔ¡£
½ñÌìÉÔ´øÁ˼¸ÑÛ£¬ÈçÊý¾Ý¿â´¥·¢Æ÷£¬¼Ü¹¹£¬Êý¾Ý¿â´¥·¢Æ÷£¬·þÎñÆ÷´¥·¢Æ÷µÈ¡£ºÜ¶àÊÇеÄÄÚÈÝ£¬ÓÐЩÊǸÅÄî·¢ÉúÁËһЩ±ä»¯¡£
ÓÐЩSQLµÃµ½ÁËÔöÇ¿¡£
Èçfromºó¿ÉÒÔ¸ú²ÉÑùÓï¾ä£¬½»²æ±í£¬ ......

ÉêÇëMSSQLÒÉÄÑÎÊÌâ°æ°æÖ÷,Ï£Íû´ó¼ÒÖ§³Ö!

»áÔ±ID£ºws_hgo
ÉêÇë°æÃæ£ºSQL ServerÒÉÄÑÎÊÌâ
ÉêÇë°æÖ÷ÀíÓÉ£ºÏ£ÍûÔÚCSDN¾¡¿ÉÄܵİïÖú´ó¼Ò,Ï£ÍûÄܹ»ºÍ´ó¼ÒÒ»ÆðÌá¸ßMSSQL¼¼Êõ
ƽ¾ùÉÏÍøÊ±¼ä(Сʱ/Ìì)£º>12Сʱ
ÊÇ·ñµ£Èιý±¾ÉçÇø»òÕ߯äËûÉçÇøÏà¹ØÖ ......

MSSQL ²Ù×÷½á¹û¼¯

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 ......

vb+mssql²éѯÎÊÌâ

±ÈÈç
Ò»¸öÊÇÓû§Áбí
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
......

tadoqueryÔÚMSSQLÖÐÖ´Ðвéѯ£¬²ÎÊýÈçºÎ¸³Öµ£¿

ÈçÌ⣬²éѯÓï¾ä²ÎÊýÓ¦¸ÃÔõôд°¡£¿
¸ø²ÎÊý¸³Öµ¡¡ÔõôŪ°¡£¿

with Query do begin
  tempParam=parameters.addparameter;
  tempParam.name='@begindate';
  tempParam.Da ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ