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

sql serverÇóÖú£¡¼±£¡£¡£¡

ÎÒÐèÒªupdateij±íÀïµÄ8Íò¶àÌõ¼Ç¼£¬ÓÉÓÚ´ÅÅÌÊ£Óà¿Õ¼äÖ»ÓÐ10¶à¸öG¡£Ã¿´ÎupdateµÄʱºò¾ÍÔì³É´ÅÅ̿ռ䲻×ã¡£¶øÇÒÿ´ÎÖ´ÐÐÍêupdateÊý¾Ý¿âµÄ´óС¶¼»áÔö¼ÓºÜ¶à¡£
ÓÐʲô°ì·¨ÄÜÔÙÕâÓÐÏ޵ĿռäÀï¸üÐÂÕâ8W¶àÌõ¼Ç¼£¬»¹ÓÐΪʲôÿ´ÎÎÒÖ´ÐÐupdateºóÊý¾Ý¿â´óС¶¼»áÔö¼Ó£¨updateûÓгɹ¦£¬Ìáʾ¿Õ¼ä²»¹»£¬µ«ÊÇÊý¾Ý¿â´óСÒÀÈ»Ôö¼ÓÁË£©¡£
Ö´ÐÐǰÓÃÏÂ
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED


SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

ÕâÊǸöʲô²Ù×÷£¿

ÒýÓÃ
ÎÒÐèÒªupdateij±íÀïµÄ8Íò¶àÌõ¼Ç¼£¬ÓÉÓÚ´ÅÅÌÊ£Óà¿Õ¼äÖ»ÓÐ10¶à¸öG¡£Ã¿´ÎupdateµÄʱºò¾ÍÔì³É´ÅÅ̿ռ䲻×ã¡£¶øÇÒÿ´ÎÖ´ÐÐÍêupdateÊý¾Ý¿âµÄ´óС¶¼»áÔö¼ÓºÜ¶à¡£
ÓÐʲô°ì·¨ÄÜÔÙÕâÓÐÏ޵ĿռäÀï¸üÐÂÕâ8W¶àÌõ¼Ç¼£¬»¹ÓÐΪʲôÿ´ÎÎÒÖ´ÐÐupdateºóÊý¾Ý¿â´óС¶¼»áÔö¼Ó£¨updateûÓгɹ¦£¬Ìáʾ¿Õ¼ä²»¹»£¬µ«ÊÇÊý¾Ý¿â´óСÒÀÈ»Ôö¼ÓÁË£©¡£

8ÍòÌõ,Ê®¸öG»¹²»¹»?
ÄãʲôÊý¾Ý?

»òÕßÿ´ÎÖ´ÐÐǰ,ÏȰÑÈÕÖ¾Çå³ýÁË.

/*
±êÌ⣺Çå³ýÈÕÖ¾ºÍÊÕËõÈÕÖ¾
×÷Õߣº°®Ð¾õÂ޷ع»ª 
ʱ¼ä£º2008-07-14
µØµã£ºÐ½®ÎÚ³ľÆë
×ÊÁÏÀ´Ô´£ºÉîÛÚÍ⾭ó¾ÖÄê¼ìÊý¾Ý¿âºÍCSDN»áÔ±adis789×Éѯsql serverÈÕ־Ϊɶ»áÔö³¤ºÜ¿ì£¬ 
ÓÐÒ»¸ö³ÌÐòÿ5ÃëÖÓдÊý¾ÝÒ»´Î£¬È»ºóÊý¾Ý¿âÈÕÖ¾¾­³£Ôö³¤ºÜ¿ì£¬Ôõô±ÜÃâÕâÑùµÄÊÂÇé·¢ÉúÄØ£¿ 
ÔõôÄÜÈÃsql serverÈÕÖ¾Ôö³¤²»ÒªÕâô¿ì£¬Êý¾ÝÎļþ²Å100MÈÕÖ¾Îļþ¾ÓÈ»1G¶à¡£
*/

SQL code:

--Çå³ýÈÕÖ¾£º
DECLARE @LogicalFileName sys


Ïà¹ØÎÊ´ð£º

sql º¯ÊýÎÊÌâ - MS-SQL Server / Ó¦ÓÃʵÀý

sqlÎÒÏëµÃµ½Ò»×Ö·û´®Îª:
sldkf|||sdeww
erkv|||rltdk
jemcl|||ligf
¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð»
ÔνñÌì²»ÊÇдÁËô

select parsen ......

ÇóÒ»ÌõSQL - MS-SQL Server / ÒÉÄÑÎÊÌâ

--drop table #T1
--drop table #T2
create Table #T1(ID int,
QueryID nvarchar(20),
ResultID1 nvarchar(20),
ResultID2 nvarchar(20))
create Table #T2(SortNo int,
QueryID nvarchar(20),
ResultID1 nv ......

ASPÁ´½ÓSQLµÄ¼òµ¥µÇ½½çÃæ - .NET¼¼Êõ / ASP.NET

protected void btnLogin_Click(object sender, EventArgs e)
  {
  SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ