SQLServerÖÐÅúÁ¿²åÈëÊý¾Ý·½Ê½µÄÐÔÄܶԱÈ
×òÌìÏÂÎç¿ìÏ°àµÄʱºò£¬ÎÞÒâÖÐÌýµ½¹«Ë¾Á½Î»Í¬ÊÂÔÚ̽ÌÖÅúÁ¿ÏòÊý¾Ý¿â²åÈëÊý¾ÝµÄÐÔÄÜÓÅ»¯ÎÊÌ⣬¶ÙʱÀ´ÁËÐËȤ£¬°Ñ×Ô¼ºµÄÏë·¨ÏòÁ½Î»Í¬ÊÂ˵ÁËһϣ¬ÓÚÊÇÓÐÁ˱¾ÎÄ¡£
¹«Ë¾¼¼Êõ±³¾°£ºÊý¾Ý¿â·ÃÎÊÀࣨxxx.DataBase.Dll£©µ÷Óô洢¹ý³ÌʵÏÖÊý¾Ý¿âµÄ·ÃÎÊ¡£
¼¼Êõ·½°¸Ò»£º
ѹËõʱ¼äϳÌÐòԱд³öµÄµÚÒ»¸ö°æ±¾£¬½ö½öΪÁËÍê³ÉÈÎÎñ£¬Ã»ÓдӳÌÐòÉÏ×öÈκÎÓÅ»¯£¬ÊµÏÖ·½Ê½ÊÇÀûÓÃÊý¾Ý¿â·ÃÎÊÀàµ÷Óô洢¹ý³Ì£¬ÀûÓÃÑ»·ÖðÌõ²åÈë¡£ºÜÃ÷ÏÔ£¬ÕâÖÖ·½Ê½Ð§Âʲ¢²»¸ß£¬ÓÚÊÇÓÐÁËÇ°ÃæµÄÁ½Î»Í¬ÊÂÌÖÂÛЧÂʵ͵ÄÎÊÌâ¡£
¼¼Êõ·½°¸¶þ£º
ÓÉÓÚÊÇ¿¼Âǵ½´óÊý¾ÝÁ¿µÄÅúÁ¿²åÈ룬ÓÚÊÇÎÒÏëµ½ÁËADO.NET2.0µÄÒ»¸öеÄÌØÐÔ£ºSqlBulkCopy¡£ÓйØÕâ¸öµÄÐÔÄÜ£¬ºÜÔç֮ǰÎÒÊÇÇ××Ô×ö¹ýÐÔÄܲâÊԵģ¬Ð§Âʷdz£¸ß¡£ÕâÒ²ÊÇÎÒÏò¹«Ë¾Í¬ÊÂÍƼöµÄ¼¼Êõ·½°¸¡£
¼¼Êõ·½°¸Èý£º
ÀûÓÃSQLServer2008µÄÐÂÌØÐÔ--±íÖµ²ÎÊý£¨Table-Valued Parameter£©¡£±íÖµ²ÎÊýÊÇSQLServer2008²ÅÓеÄÒ»¸öÐÂÌØÐÔ£¬Ê¹ÓÃÕâ¸öÐÂÌØÐÔ£¬ÎÒÃÇ¿ÉÒÔ°ÑÒ»¸ö±íÀàÐÍ×÷Ϊ²ÎÊý´«µÝµ½º¯Êý»ò´æ´¢¹ý³ÌÀï¡£²»¹ý£¬ËüÒ²ÓÐÒ»¸öÌص㣺±íÖµ²ÎÊýÔÚ²åÈëÊýÄ¿ÉÙÓÚ 1000 µÄÐÐʱ¾ßÓкܺõÄÖ´ÐÐÐÔÄÜ¡£
¼¼Êõ·½°¸ËÄ£º
¶ÔÓÚµ¥ÁÐ×ֶΣ¬¿ÉÒÔ°ÑÒª²åÈëµÄÊý¾Ý½øÐÐ×Ö·û´®Æ´½Ó£¬×îºóÔÙÔÚ´æ´¢¹ý³ÌÖвð·Ö³ÉÊý×飬ȻºóÖðÌõ²åÈë¡£²éÁËһϴ洢¹ý³ÌÖвÎÊýµÄ×Ö·û´®µÄ×î´ó³¤¶È£¬È»ºó³ýÒÔ×ֶεij¤¶È£¬Ëã³öÒ»¸öÖµ£¬ºÜÃ÷ÏÔÊÇ¿ÉÒÔÂú×ãÒªÇóµÄ£¬Ö»ÊÇÕâÖÖ·½Ê½¸úµÚÒ»ÖÖ·½Ê½±ÈÆðÀ´£¬ËƺõûʲôÌá¸ß£¬ÒòΪÔÀí¶¼ÊÇÒ»ÑùµÄ¡£
¼¼Êõ·½°¸Î壺
¿¼ÂÇÒì²½´´½¨¡¢ÏûÏ¢¶ÓÁеȵȡ£ÕâÖÖ·½°¸ÎÞÂÛ´ÓÉè¼ÆÉÏ»¹ÊÇ¿ª·¢ÉÏ£¬ÄѶȶ¼ÊÇÓеġ£
¼¼Êõ·½°¸Ò»¿Ï¶¨ÊÇÒª±»·ñµôµÄÁË£¬Ê£ÏµľÍÊÇÔÚ¼¼Êõ·½°¸¶þ¸ú¼¼Êõ·½°¸ÈýÖ®¼ä×öÒ»¸ö¾ñÔñ£¬¼øÓÚ¹«Ë¾Ä¿Ç°µÄÇé¿ö£¬¼¼Êõ·½°¸Ëĸú¼¼Êõ·½°¸Îå¾ÍÏȲ»¿¼ÂÇÁË¡£
½ÓÏÂÀ´£¬ÎªÁËÈôó¼Ò¶Ô±íÖµ²ÎÊýµÄ´´½¨¸úµ÷ÓÃÓиü¸ÐÐÔµÄÈÏʶ£¬ÎÒ½«Ð´µÄ¸üÏêϸЩ£¬ÎÄÕ¿ÉÄÜÒ²»áÉÔ³¤Ð©£¬²»¹Øעϸ½ÚµÄÅóÓÑÃÇ¿ÉÒÔÑ¡ÔñÌøԾʽµÄÔĶÁ·½Ê½¡£
ÔÙ˵һϲâÊÔ·½°¸°É£¬²âÊÔ×ܹ²·ÖÈý×飬һ×éÊDzåÈëÊýÁ¿Ð¡ÓÚ1000µÄ£¬ÁíÍâÁ½×éÊDzåÈëÊý¾ÝÁ¿´óÓÚ1000µÄ£¨ÕâÀïÎÒÃÇ·Ö±ðÈ¡10000¸ú1000000£©£¬Ã¿×é²âÊÔÓÖ·Ö10´Î£¬È¡Æ½¾ùÖµ¡£Ôõô×ö¶¼Ã÷°×ÁË£¬Let’s go!
1.´´½¨±í¡£
ΪÁ˼òµ¥£¬±íÖÐÖ»ÓÐÒ»¸ö×ֶΣ¬ÈçÏÂͼËùʾ£º
2.´´½¨±íÖµ²ÎÊýÀàÐÍ
ÎÒÃÇ´ò¿ª²éѯ·ÖÎöÆ÷£¬È»ºóÔÚ²éѯ·ÖÎöÆ÷ÖÐÖ´ÐÐÏÂÁдúÂ룺
Create Type PassportTableType as Table
(
PassportKey nvarchar(50)
)
Ö´Ðгɹ¦ÒÔºó£¬ÎÒÃÇ´ò¿ªÆóÒµ¹ÜÀíÆ÷£¬°´Ë³ÐòÒÀ´ÎÕ¹¿ªÏÂÁнڵã--Êý¾Ý¿â¡¢Õ
Ïà¹ØÎĵµ£º
SQL-Structured Query Language
--(¿ªÆôSQL·þÎñ£ºnet start mssqlserver)
--(ÔÚÃüÁîÐÐÖÐÊäÈë'sqlwb'ÃüÁî¿É´ò¿ªSQL¹ÜÀíÆ÷ )
--(Èç¹ûÒªÖ´ÐжàÌõÃüÁîÖеÄÒ»Ìõ,Êó±êÑ¡¶¨ºóÔÙ°´F5Ö´ÐÐ)
create database sales --´´½¨Ò»¸öÃûΪsalesµÄÊý¾Ý¿â
on
(
name='sales_dat ......
¸ÅÊö£º
ÅäÖà Web ͬ²½
url: http://technet.microsoft.com/zh-cn/library/ms151810(SQL.90).aspx
ÈôÒª¶Ô¸´ÖÆʹÓà Web ͬ²½£¬ÇëÖ´ÐÐÏÂÁв½Ö裺
ÅäÖ÷¢²¼£¬ÒÔÔÊÐíʹÓà Web ͬ²½¡£
ÅäÖÃÔËÐÐ Microsoft Internet ÐÅÏ¢·þÎñ (IIS) µÄ¼ÆËã»úÒÔͬ²½¶©ÔÄ¡£Ö§³Ö IIS 5.0 ºÍ 6.0 °æ¡£
ÅäÖÃÒ»¸ö»ò¶à¸ö¶©ÔÄÒÔʹÓà Web ͬ²½¡£
......
ÈçºÎÅäÖö©ÔÄÒÔʹÓà Web ͬ²½ (SQL Server Management Studio)
±¾Ö÷ÌâµÄ¹ý³ÌÊÇΪºÏ²¢¸´ÖÆÅäÖà Web ͬ²½µÄµÚÈý¸ö²½Öè¡£Ó¦ÔÚÆôÓ÷¢²¼²¢ÅäÖà Microsoft Internet ÐÅÏ¢·þÎñ (IIS) ºóÖ´Ðд˲½Öè¡£ÓйØÅäÖùý³ÌµÄ¸ÅÊö£¬Çë²ÎÔÄ ÈçºÎΪºÏ²¢¸´ÖÆÅäÖà Web ͬ²½ (SQL Server Management Studio)¡£ÔÚÍê³É±¾Ö÷ÌâÖеĹý³Ìºó£¬Çëͬ²½´´½ ......
1¡¢²é¿´ÔÊý¾Ý¿â±¸·ÝÇé¿ö£ºRESTORE FILELISTONLY from DISK = 'c:\NMGCNC-BABY_2009-4-1.dat' WITH NOUNLOAD, FILE = 1
2¡¢½øÐÐÊý¾Ý¿â»¹Ô£º
restore database babyAndwed from DISK = 'c:\NMGCNC-BABY_2009-4-1.dat' with move 'babyAndwed_Data' to
'c:\NMGCNC-BABY_Data.MDF',move 'babyAndwed_Log' to 'c:\NMGCNC-B ......
using System.Data.SqlClient;
using System.Data.OleDb;
private void button1_Click(object sender, EventArgs e)
{
OleDbConnection conn = null;
try
&nbs ......