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

´óÁ¿SQLÓï¾äÖ´ÐÐ

±ÈÈç˵ÎÒÓÐINSERT £¬UPDATE £¬DELETE £¬SELECT Óï¾ä¸÷1000ÌõÒªÖ´ÐÐ,ÿÌõÖ´ÐеÄÊý¾ÝÁ¿¶¼ÔÚ1WÐÐÒÔÉÏ£¬Èç¹û°ÑÕâ4000ÌõÓï¾äÖ±½ÓÖ´ÐУ¬»á³öÏÖϵͳ±ÀÀ£


ÎÒÏÖÔÚÊÇÏëÒªÖ±½ÓÖ´ÐÐÕâ4000ÌõÓï¾ä£¬È»ºóÓÖ¿ÉÒÔµÈÉÏÒ»ÌõÖ´ÐÐÍê³öÏÖ½á¹ûºóÔÙÖ´ÐÐÏÂÒ»Ìõ£¬½á¹û¿ÉÊÓ£¬Ä¿Ç°ÎҵIJÙ×÷ÊÇÖðÌõÊÖ¹¤Ö´ÐÐ

ÎÒÏëÎʵÄÊÇÓÐûÓа취²»ÓÃÿÌõ¶¼ÊÖ¹¤Ö´ÐУ¬µ«¸úÿÌõ¶¼ÊÖ¹¤Ö´Ðеõ½Ò»ÑùµÄ½á¹û

¿ÉÄÜ˵µÄ²»ÊǺÜÇå³þ£¬Çó½â~~~
WAITFOR

Äã×ö³É¸öÑ­»·,Ò»¸öÒ»¸öÔËÐоÍÊÇÁË.

»òÕß°ÑËÄǧÌõдµ½Ò»Æð,ÔËÐÐ.

ÀýÈç:
insert sql1
insert sql2
...
update sql1
...



順Ðò執ÐÐ~~

SQL code:

WAITFOR DELAY '00:00:05' --µÈ´ý5Ãë


×ö³É´æ´¢¹ý³Ì ×ö³É¼¸¸ö´æ´¢¹ý³Ì

ÒýÓÃ
Äã×ö³É¸öÑ­»·,Ò»¸öÒ»¸öÔËÐоÍÊÇÁË.

»òÕß°ÑËÄǧÌõдµ½Ò»Æð,ÔËÐÐ.

ÀýÈç:
insert sql1
insert sql2
...
update sql1
...




Õâ¸ö¸ú3Â¥Ò»Ñù

ÎÒÏë˵µÄÊÇÿÌõµÄÊý¾ÝÁ¿¶¼ºÜ´ó£¬Èç¹ûÒ»ÏÂ×ÓÖ´ÐÐ4000£¬ÏµÍ³¾Í±ÀÀ£ÁË£¬»¹ÓиöÒÉÎʾÍÊÇÄѵÀÖ±½ÓÔËÐв»ÊÇÖðÐÐÖ´ÐеÄÂð£¿

ÒýÓÃ
SQL codeWAITFOR DELAY'00:00:05'--µÈ´ý5Ãë

¸öÈ˾õµÃÕâ¸öÏë·¨²»´í

ºÇºÇ£¬×î¼òµ¥µÄÒ»¸ö×ö·¨£¬ÄãµÄ·þÎñÆ÷Èç¹ûÊǶàºËµÄ»°
ÔÚÊý¾Ý¿â ·


Ïà¹ØÎÊ´ð£º

SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ïæ£¡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿

sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿ÎÒÖ¸µÄÊÇfor´¥·¢Æ÷£¬ÄÇÆäËûµÄÄØ£¿£¿
ʲôÒâ˼£¿

¿ÉÒÔµÄ

10¸ö¶¼Ã»ÎÊÌâ

¿ÉÊÇÎÒдÁËÁ½¸öfor insert ´¥·¢Æ÷£¬Ôì³É½ø³Ì×èÈûÁËÄØ£¿Ôõô°ìÄØ£¿Çë¸ßÈËÖ¸µã
......

C# Á¬½ÓSQLÊý¾Ý¿â³£ÓõÄÁ¬½Ó×Ö·û´®¸ÃÈçºÎд£¿

£¨1£©string ConnString = "server=localhost;integrated security=sspi;database=pubs;";   
£¨2£©string strConnection="user uid=sa;pwd=123456;Database=test;Server=test;Connect ......

°ïÎÒÖ¸µãÏÂSQL SERVERÊý¾Ý¿âÁ´½ÓÎÊÌ⣬лл£¡

C# code:
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.We ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ