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)
)
Ö´Ðгɹ¦ÒÔºó£¬ÎÒÃÇ´ò¿ªÆóÒµ¹ÜÀíÆ÷£¬°´Ë³ÐòÒÀ´ÎÕ¹¿ªÏÂÁнڵã--Êý¾Ý¿â¡¢Õ
Ïà¹ØÎĵµ£º
SQLSERVER--һЩ¾µäÎÊÌâ×ܽá
2007-04-01¡¡01:04:06
´óÖÐС
/**********************************/
--»ñµÃijһÌìËùÔÚÄêµÄµÚÒ»Ìì
declare @a datetime,@b datetime,@sum int,@num int,@res varchar(20)
select @a='1-6-1968'
select @b='2006-4-8'
select @sum=year(@a)
select @res=ltrim(cast(@sum as ......
SQLServerºÍOracleÊÇ´ó¼Ò¾³£Óõ½µÄÊý¾Ý¿â£¬ÔÚ´Ë×ܽá³öÕâЩ³£Óú¯ÊýÒÔ¹©
´ó¼Ò²Î¿¼¡£
Êýѧº¯Êý
¡¡¡¡1.¾ø¶ÔÖµ
¡¡¡¡S:select abs(-1) value
¡¡¡¡O:select abs(-1) value from dual
¡¡¡¡2.È¡Õû(´ó)
¡¡¡¡S:select ceiling(-1.001) value
¡¡¡¡O:select ceil(-1.001) value from dual
¡¡¡¡3.È¡Õû£¨Ð¡£©
¡¡¡¡S:s ......
SQL-Structured Query Language
--(¿ªÆôSQL·þÎñ£ºnet start mssqlserver)
--(ÔÚÃüÁîÐÐÖÐÊäÈë'sqlwb'ÃüÁî¿É´ò¿ªSQL¹ÜÀíÆ÷ )
--(Èç¹ûÒªÖ´ÐжàÌõÃüÁîÖеÄÒ»Ìõ,Êó±êÑ¡¶¨ºóÔÙ°´F5Ö´ÐÐ)
create database sales --´´½¨Ò»¸öÃûΪsalesµÄÊý¾Ý¿â
on
(
name='sales_dat ......
ÈçºÎΪ Web ͬ²½ÅäÖà IIS
±¾Ö÷ÌâÖеĹý³ÌÊÇΪºÏ²¢¸´ÖÆÅäÖà Web ͬ²½µÄµÚ¶þ¸ö²½Öè¡£Ó¦ÔÚΪ Web ͬ²½ÆôÓ÷¢²¼ºóÖ´Ðд˲½Öè¡£ÓйØÅäÖùý³ÌµÄ¸ÅÊö£¬Çë²ÎÔÄ ÅäÖà Web ͬ²½¡£Íê³É±¾Ö÷ÌâÖеĹý³Ìºó£¬Çë¼ÌÐøÖ´ÐеÚÈý¸ö²½Öè“ÅäÖö©ÔÄÒÔʹÓà Web ͬ²½”¡£ÏÂÁÐÖ÷ÌâÖн«½éÉܵÚÈý¸ö²½Ö裺
SQL Server Management Studio: ......
ÏÖÔÚÒ»°ã³£ÓõÄÓÐÒÔÏÂ2ÖÖ·½·¨:
1. select top @pagesize * from table1 where id not in (select top @pagesize*(@page-1) id from table1 order by id) order by id
2. select * from (select top @pagesize * from (select top @pagesize*@page * from table1 order by id) a order by id desc) b or ......