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)
)
Ö´Ðгɹ¦ÒÔºó£¬ÎÒÃÇ´ò¿ªÆóÒµ¹ÜÀíÆ÷£¬°´Ë³ÐòÒÀ´ÎÕ¹¿ªÏÂÁнڵã--Êý¾Ý¿â¡¢Õ
Ïà¹ØÎĵµ£º
¸ÅÊö£º
ÅäÖà Web ͬ²½
url: http://technet.microsoft.com/zh-cn/library/ms151810(SQL.90).aspx
ÈôÒª¶Ô¸´ÖÆʹÓà Web ͬ²½£¬ÇëÖ´ÐÐÏÂÁв½Ö裺
ÅäÖ÷¢²¼£¬ÒÔÔÊÐíʹÓà Web ͬ²½¡£
ÅäÖÃÔËÐÐ Microsoft Internet ÐÅÏ¢·þÎñ (IIS) µÄ¼ÆËã»úÒÔͬ²½¶©ÔÄ¡£Ö§³Ö IIS 5.0 ºÍ 6.0 °æ¡£
ÅäÖÃÒ»¸ö»ò¶à¸ö¶©ÔÄÒÔʹÓà Web ͬ²½¡£
......
Ò»¡¢SQLServer ͨÓÃË÷Òý×Ö¶Î
1¡¢Primary Key's Ö÷¼ü
2¡¢Foreign Key's Íâ¼ü
3¡¢Ö§³ÖSELECT¡¢INSERT¡¢UPDATEºÍDELETEÃüÁîµÄ×ֶΠ:
(1)¡¢INNER JOIN
(£²)¡¢RIGHT | LEFT OUTER JOIN
(£³)¡¢WHERE
(£´)¡¢ORDER BY
(£µ)¡¢GROUP BY
(£¶)¡¢HAVING
¶þ¡¢´´½¨Ë÷ÒýµÄÆäËûÒòËØ(Ö÷ÒªÒòËض¼ÒòΪË÷ÒýÊÇÊý¾Ý±íÍⲿ ......
sqlserver 2000ÅÅÃûº¯Êý
Ãû´ÎÉú³É·½Ê½1,Öظ´Ê±ºÏ²¢Ãû´Î
SELECT *¡¡,¡¡Place=(SELECT COUNT(DISTINCT Score) +1 from jh03 WHERE Score >= a.Score)
from jh03 a
ORDER BY Place
Ãû´ÎÉú³É·½Ê½2 , Öظ´Ê±±£ÁôÃû´Î¿Õȱ
SELECT * , Place=(SELECT COUNT(Score) from jh03 WHERE Score > a.Score) + 1
from j ......
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 ......
Ë÷Òý·ÖΪÁ½´óÀà:¾Û¼¯Ë÷ÒýºÍ·Ç¾Û¼¯Ë÷Òý
Ò»¡¢¾Û¼¯Ë÷Òý
µ±Êý¾Ý±íÖеÄÒ»Áб»È·¶¨ÎªÖ÷¼üºó,SQLServer»á×Ô¶¯ÎªËü½¨Á¢¾Û¼¯Ë÷Òý,ÒòΪ¾Û¼¯Ë÷ÒýÊDZêʶÿ¸ö¼Ç¼Ðеļü,ËùÒÔËü½«±»Ó¦Óõ½Ã¿¸ö²éѯÖÐ.
¶þ¡¢·Ç¾Û¼¯Ë÷Òý
·Ç¾Û¼¯Ë÷ÒýµÄÇé¿ö¾Í±È½Ï¸´ÔÓÁË,ÒòΪËüÊÇÏà¶ÔÓÚ±í¶ÀÁ¢×éÖ¯µÄ,ÔÚSQLServerÖÐÓе¥¶ÀµÄ½á¹¹À´´æ´¢·Ç¾Û¼¯Ë÷Òý.
......