ÈçºÎÓÐЧµÄ·ÀÖ¹SQLÁ¬½Ó×Ö·û´®×¢Èë
¸ÅÄÔÚ±àд°²È«´úÂëʱ£¬×îÖØÒªµÄ¹æÔòÖ®Ò»¾ÍÊÇ“¾ø¶Ô²»ÒªÃ¤Ä¿µÄÏàÐÅÓû§µÄÊäÈ딡£
ÀûÓÃADO.NET 2.0µÄSqlConnectionStringBuilderÀàÉú³ÉÊý¾Ý¿âÁ¬½Ó×Ö·û´®£¬Ëü¿ÉÒÔÓÐЧµÄ·ÀÖ¹“SQLÁ¬½Ó×Ö·û´®¶ñÒâ×¢È딣¬ÒòΪÕâ¸öÀàÊÇרÃÅΪSQL SERVERÉè¼ÆµÄËùÒÔ£»Ëü¼æÈݾÉʽ¹Ø¼ü×Ö¡£¹ØÓÚÈçºÎʹÓÃSqlConnectionStringBuilderÀ࣬Çë²Î¿¼ÎÒÒÔǰдµÄһƪ“ÖÇÄÜÊý¾Ý¿âÁ¬½ÓÉú³ÉÆ÷”ÎÄÕÂÀï¡£
·ÀÖ¹SQLÊý¾Ý¿âÁ¬½Ó×Ö·û´®Ê¾Àý
C#ºǫ́ʾÀý´úÂ룺
SqlConnectionStringBuilder bldr = new SqlConnectionStringBuilder();
bldr.DataSource = @".\SQLExpress";
bldr.InitialCatalog = "Pubs";
bldr.UserID = textBox1.Text;
bldr.Password = textBox2.Text;
¸Õ²Å¿´µ½Ç°Ì¨Óû§ÔÚÓû§ÃûÊäÈëµÄÓû§Ãû×Ö·û´®£¬¾ÍÊǶñÒâSQL×¢È룬¶øSqlConnectionStringBuilder»á°Ñ
“Óû§Ãû£»Data Source=Northwind”µÄ×Ö·û´®×÷Ϊ“UesrID”À´µÇ¼Êý¾Ý¿â¡£Õâ¾Í·ÀÖ¹¶ñÒâµÄ×¢ÈëÁË¡£
×îºóÏ£ÍûÄܺÍ־ͬµÀºÏµÄ¿ª·¢Í¬Ö¾£¬Ò»Æðѧϰ£¬Ò»Æð·ÖÏí¡£Ð»Ð»
ÍÆ¼öÁ´½Ó:»ÝÆÕºÚ°×¼¤¹â´òÓ¡»ú/°®ÆÕÉúÕëʽ´òÓ¡»ú
Ïà¹ØÎĵµ£º
1.¼ì²éÄãÊÇ·ñÏÞÖÆÁËÎļþÔö³¤:
ÆóÒµ¹ÜÀíÆ÷--ÓÒ¼üÄãµÄÊý¾Ý¿â--ÊôÐÔ--Êý¾ÝÎļþ--¿´¿´ÓÐûÓÐÉèÖÃÎļþµÄ×î´óÖµ
2.¼ì²éÄãµÄ´ÅÅÌ·ÖÇø¸ñʽ,Èç¹û²»ÊÇNTFS·ÖÇø,Ôò»áÓÐÏÞÖÆ,½«´ÅÅÌ·ÖÇø¸ñʽ¸Ä³ÉNTFS
&n ......
Maximizing SQL*Loader Performance
SQL*Loader is flexible and offers many options that should be considered to maximize the speed of data loads. These include:
¡ñ Use Direct Path Loads - The conventional path loader essentially loads the data by usin ......
SqlÓï¾ä
1. ˵Ã÷£º¸´ÖƱí(Ö»¸´Öƽṹ£¬Ô´±íÃû£ºa£¬Ð±íÃû£ºb) SQL:select * into bfrom awhere 1<>1;
2. ˵Ã÷£º¿½±´± ......
drop table #Tmp --ɾ³ýÁÙʱ±í#Tmp
create table #Tmp --´´½¨ÁÙʱ±í#Tmp
(
ID int IDENTITY (1,1) not null, --´´½¨ÁÐID,²¢ÇÒÿ´ÎÐÂÔöÒ»Ìõ¼Ç¼¾Í»á¼Ó1
WokNo &nb ......