´óÁ¿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Ãë ¸öÈ˾õµÃÕâ¸öÏë·¨²»´í ºÇºÇ£¬×î¼òµ¥µÄÒ»¸ö×ö·¨£¬ÄãµÄ·þÎñÆ÷Èç¹ûÊǶàºËµÄ»° ÔÚÊý¾Ý¿â ·
Ïà¹ØÎÊ´ð£º
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿ 21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30 Ö¸µ ......
Ö´ÐеÄ˳Ðò£º 1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã© Ñ¡ÔñºÃÎļþºó µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏ 2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql 3 ......
sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿ÎÒÖ¸µÄÊÇfor´¥·¢Æ÷£¬ÄÇÆäËûµÄÄØ£¿£¿ ʲôÒâ˼£¿ ¿ÉÒ﵀ 10¸ö¶¼Ã»ÎÊÌâ ¿ÉÊÇÎÒдÁËÁ½¸öfor insert ´¥·¢Æ÷£¬Ôì³É½ø³Ì×èÈûÁËÄØ£¿Ôõô°ìÄØ£¿Çë¸ßÈËÖ¸µã ......
£¨1£©string ConnString = "server=localhost;integrated security=sspi;database=pubs;"; £¨2£©string strConnection="user uid=sa;pwd=123456;Database=test;Server=test;Connect ......
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 ......