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 ͬ²½ÅäÖà IIS
¸üÐÂÈÕÆÚ£º 2006 Äê 12 Ô 12 ÈÕ
±¾Ö÷ÌâÖеĹý³ÌÊÇΪºÏ²¢¸´ÖÆÅäÖà Web ͬ²½µÄµÚ¶þ¸ö²½Öè¡£Ó¦ÔÚΪ Web ͬ²½ÆôÓ÷¢²¼ºóÖ´Ðд˲½Öè¡£ÓйØÅäÖùý³ÌµÄ¸ÅÊö£¬Çë²ÎÔÄ ÅäÖà Web ͬ²½¡£Íê³É±¾Ö÷ÌâÖеĹý³Ìºó£¬Çë¼ÌÐøÖ´ÐеÚÈý¸ö²½Öè“ÅäÖö©ÔÄÒÔʹÓà Web ͬ²½”¡£ÏÂÁÐÖ÷ÌâÖн«½éÉܵÚÈý¸ö²½Öè£ ......
ÈçºÎΪ Web ͬ²½ÅäÖà IIS
±¾Ö÷ÌâÖеĹý³ÌÊÇΪºÏ²¢¸´ÖÆÅäÖà Web ͬ²½µÄµÚ¶þ¸ö²½Öè¡£Ó¦ÔÚΪ Web ͬ²½ÆôÓ÷¢²¼ºóÖ´Ðд˲½Öè¡£ÓйØÅäÖùý³ÌµÄ¸ÅÊö£¬Çë²ÎÔÄ ÅäÖà Web ͬ²½¡£Íê³É±¾Ö÷ÌâÖеĹý³Ìºó£¬Çë¼ÌÐøÖ´ÐеÚÈý¸ö²½Öè“ÅäÖö©ÔÄÒÔʹÓà Web ͬ²½”¡£ÏÂÁÐÖ÷ÌâÖн«½éÉܵÚÈý¸ö²½Ö裺
SQL Server Management Studio: ......
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 ......
SQL-Structured Query Language
--(¿ªÆôSQL·þÎñ£ºnet start mssqlserver)
--(ÔÚÃüÁîÐÐÖÐÊäÈë'sqlwb'ÃüÁî¿É´ò¿ªSQL¹ÜÀíÆ÷ )
--(Èç¹û ......
ÿ´Î´ò¿ªSQLServer²éѯ·ÖÎöÆ÷ºó£¬ÔÚÁ¬½Ó´°¿ÚÀïµÄSQLServer·þÎñÆ÷Ñ¡ÔñÏÂÀ¿òºÍµÇ¼Óû§ÃûÊäÈë¿òÀﶼ»áÁôÓÐÀúÊ·µÇ¼µÄ¼Ç¼£¬ÓÐʱºòÎÒÃÇÊDz»Ï£ÍûÕâÑùµÄ£¬±ÈÈçÔÚÒ»¸ö·Ç˽ÓÐÁìµØ×öÁËÔÝʱµÄ¿ª·¢ºó£¬²»ÏëÁôÏÂÈκÎÁ¬½ÓÔ¶³ÌÊý¾Ý¿âµÄ¼Ç¼£¬ÈçºÎɾ³ýÄØ£¿»¹ÊÇ×¢²á±í£¬ÕÒµ½ÒÔÏ·¾¶£º
HKEY_CURRENT_USER\Software\Microsoft\Microsoft&n ......