sql serverÇóÖú£¡¼±£¡£¡£¡
ÎÒÐèÒªupdateij±íÀïµÄ8Íò¶àÌõ¼Ç¼£¬ÓÉÓÚ´ÅÅÌÊ£Óà¿Õ¼äÖ»ÓÐ10¶à¸öG¡£Ã¿´ÎupdateµÄʱºò¾ÍÔì³É´ÅÅ̿ռ䲻×ã¡£¶øÇÒÿ´ÎÖ´ÐÐÍêupdateÊý¾Ý¿âµÄ´óС¶¼»áÔö¼ÓºÜ¶à¡£
ÓÐʲô°ì·¨ÄÜÔÙÕâÓÐÏ޵ĿռäÀï¸üÐÂÕâ8W¶àÌõ¼Ç¼£¬»¹ÓÐΪʲôÿ´ÎÎÒÖ´ÐÐupdateºóÊý¾Ý¿â´óС¶¼»áÔö¼Ó£¨updateûÓгɹ¦£¬Ìáʾ¿Õ¼ä²»¹»£¬µ«ÊÇÊý¾Ý¿â´óСÒÀÈ»Ôö¼ÓÁË£©¡£
Ö´ÐÐǰÓÃÏÂ
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
ÕâÊǸöʲô²Ù×÷£¿
8ÍòÌõ,Ê®¸öG»¹²»¹»?
ÄãʲôÊý¾Ý?
»òÕßÿ´ÎÖ´ÐÐǰ,ÏȰÑÈÕÖ¾Çå³ýÁË.
/*
±êÌ⣺Çå³ýÈÕÖ¾ºÍÊÕËõÈÕÖ¾
×÷Õߣº°®Ð¾õÂ޷ع»ª
ʱ¼ä£º2008-07-14
µØµã£ºÐ½®ÎÚ³ľÆë
×ÊÁÏÀ´Ô´£ºÉîÛÚÍâ¾Ã³¾ÖÄê¼ìÊý¾Ý¿âºÍCSDN»áÔ±adis789×Éѯsql serverÈÕ־Ϊɶ»áÔö³¤ºÜ¿ì£¬
ÓÐÒ»¸ö³ÌÐòÿ5ÃëÖÓдÊý¾ÝÒ»´Î£¬È»ºóÊý¾Ý¿âÈÕÖ¾¾³£Ôö³¤ºÜ¿ì£¬Ôõô±ÜÃâÕâÑùµÄÊÂÇé·¢ÉúÄØ£¿
ÔõôÄÜÈÃsql serverÈÕÖ¾Ôö³¤²»ÒªÕâô¿ì£¬Êý¾ÝÎļþ²Å100MÈÕÖ¾Îļþ¾ÓÈ»1G¶à¡£
*/
SQL code:
--Çå³ýÈÕÖ¾£º
DECLARE @LogicalFileName sys
Ïà¹ØÎÊ´ð£º
sqlÎÒÏëµÃµ½Ò»×Ö·û´®Îª:
sldkf|||sdeww
erkv|||rltdk
jemcl|||ligf
¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð»
ÔνñÌì²»ÊÇдÁËô
select parsen ......
--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 ......
protected void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......