SQL Server 2008 R2 Ó¦Óü°¶à·þÎñÆ÷¹ÜÀí
ÔÚ¼¤ÁÒµÄÊг¡¾ºÕù»·¾³Ï£¬ÉÌÈ˶ÔÊг¡»·¾³µÄ°ÑÎպ;ö²ßÖ±½Ó¹Øϵµ½Êг¡µÄÇ÷ÊƺͻúÓö£¬¶Ô¿Í»§ÐèÇóµÄ¿ìËÙÏàÓ¦Äܹ»Õ¼¾¡Êг¡µÄÏÈ»ú¡£ÔÚµ±½ñÉç»áµÄÈÕ³£ÉÌÎñ»î¶¯ÖУ¬ÒÔÍù»ýÀÛµÄÏà¹ØÉÌÒµÊý¾ÝÄܹ»ÎªºóÐøµÄÒµÎñ»î¶¯ÌṩÁ¼ºÃµÄ²Î¿¼ºÍÏòµ¼¡£ÔçÔÚ10ÓàÄêÇ°£¬ÉÌÒµÖÇÄÜ£¨Business Intelligence£¬Ï³ÆBI£©³§É̾ÍÒѾ¿ªÊ¼´óÕÅÆì¹ÄµÄÐû´«ºÍÆÕ¼°BIÓ¦ÓóÌÐòµÄ¿ÚºÅ¡£È»¶ø£¬Ê±ÖÁ½ñÈÕ£¬ÎÒÃÇÒÀÈ»ÀëÕâ¸öÄ¿±ê·Ç³£µÄÒ£Ô¶¡£Ò»·½Ã棬BI¹¤¾ß±¾ÉíµÄ²»ÍêÉÆʹµÃBIÔÚÆóÒµÖеÄʹÓÃÂʷdz£µÄµÍ£»ÁíÒ»·½Ã棬ºÜ¶àÆóҵ̫¹ýÓÚÒÀ¿¿Ö±¾õÀ´½øÐоö²ß£¬²»»á³ä·ÖÀûÓÃÊÖÖлýÔܵÄÒÔÍùÐÅÏ¢½øÐзÖÎöºÍʹÓã¬ÓÐЩÆóÒµ¸ß¹Ü²¢Î´ÈÏʶµ½BIµÄ¼ÛÖµËùÔÚ£¬ËûÃÇÉõÖÁÓÚÓÃBIϵͳ×ö×ÅERPÀ´Óá£È»¶øÀúÊ·µÄ·¢Õ¹¸æËßÎÒÃÇ£¬¾ø´ó¶àÊýµÄÊг¡ÐÐΪÊÇÓйæÂÉ¿Éѵģ¬ÒÔÍùµÄͶ×ʹæÂÉÍùÍù»á¶ÔºóÐøͶ×ÊÐÐΪÓÐ×ÅDZÒÆĬ»¯µÄÓ°Ïì¡£ ¾¡¹ÜÈç´Ë£¬»¹ÊÇÓв»ÉÙÆóÒµÔÙ½èÖúBI³ä·ÖµÄÁ˽âºÍÕÆÎÕÔÚÊý¾ÝÖеļÛÖµ£¬ÒÔ¸ÄÉÆ×ÔÉí·þÎñ£¬Í¬Ê±ÌáÉý¾ÓªÒµ¼¨ºÍЧÂÊ¡£Èç¹ûÆóÒµÏëÈøü¶àµÄÔ±¹¤´Ó×ÔÉí¸Úλ³ö·¢³ä·ÖµÄʹÓÃBI¾Í±ØÐë×öµ½ÒÔϼ¸µã£ºÊ×ÏÈÆóÒµ±ØÐë¶ÔÒÔÍùÊý¾ÝµÄÕä¹ó¼ÛÖµÓÐ×ųä·ÖµÄÈÏʶ£¬¶øBI³§ÉÌÄܹ»Ìṩ³É±¾¸üµÍµÄBIÊÚȨºÍÅäÖ÷½°¸¡£Æä´Î£¬BI½çÃæÓ¦µ±×öµ½¼ò½àºÍÈËÐÔ»¯¾¡Á¿ÒÔÓû§×îÊìϤºÍ×îÊÊÓ¦µÄ·½Ê½À´Õ¹ÏÖÊý¾Ý£¬ÒòΪ²¢²»ÊÇËùÓÐʹÓÃBIµÄÈËÔ±¶¼ÊÇÕâ·½ÃæµÄר¼Ò£¬¸ü¶àµÄÈËÖ»ÊǶÔËùÔÚÐÐÒµ±È½ÏÊìϤ£¬Èç¹ûÄܸøËûÃÇÒ»¸öÍÚ¾òÊý¾Ý¼ÛÖµµÄ;¾¶£¬ËûÃǾÍÄܹ»´´Ôì¸ü¶àµÄÀûÈó¡£×îºó£¬ÉîÈëÆÕ¼°BI²»½öÐèÒª¼¼ÊõÉϵĸïУ¬¸üÖØÒªµÄÊǵ÷¶¯Óû§µÄ»ý¼«ÐÔ£¬ÌṩÓëËûÃǸ߶ÈÏàÎǺϵÄÐÅÏ¢£¬ÎªËûÃǵÄÅжϺ;ö²ßÌṩÓÐÒâÒåµÄ°ïÖú¡£ Microsoft¼´½«·¢²¼µÄSQL Server 2008 R2ÌṩÁËÒ»¸öÈ«ÃæµÄÉÌÒµÖÇÄÜ(BI)½â¾ö·½°¸£¬ËüΪÊý¾Ý²Ö´¢¡¢·ÖÎöºÍÉú³É±¨±íÌṩÁËÒ»¸öÀ©Õ¹µÄÊý¾Ýƽ̨£¬²¢ÎªÖÕ¶ËÓû§ÌṩÁË¿ÉÒÔÓÃÀ´·ÃÎʺͷÖÎöÉÌÒµÐÅÏ¢µÄÇ¿´óµÄºÍÖ±¾õ¹¤¾ß¡£MicrosoftÉÌÒµÖÇÄÜ¡°Ìṩ¸øÖնˡ±µÄºËÐÄÊÇMicrosoft SQL Server 2008£¬Ëü×÷ΪȫÃæµÄÊý¾Ý·þÎñƽ̨£¬Ê¹Óû§Äܹ»£º - ͳһÆóÒµÖÐËùÓÐÊý¾ÝµÄ´æ´¢ºÍ·ÃÎÊ¡£ - ½¨Á¢ºÍ¹ÜÀí¸´ÔÓµÄÉÌÒµÖÇÄܽâ¾ö·½°¸¡£ - SQL Server 2008ÐγÉÁËËùÌṩµÄÕâ¸öÇ¿´óµÄÉÌÒµÖÇÄܵĻù´¡£¬ÆäÖаüÀ¨SQL ServerÊý¾Ý¿âÒýÇæ¡¢¼¯³É·þÎñºÍ±¨±í·þÎñ ͼ1 SQL Server 2008 R2¾ßÓÐÇ¿´ó¶ø·á¸»µÄ½Ó¿Ú SQL Server2008 R2×÷ΪÆóÒµ¼°Ó¦ÓõÄÓÅÊÆÖ÷ÒªÓÐÒÔϼ¸µã£º
Ïà¹ØÎĵµ£º
´Ó²©¿ÍÔ°Öп´µ½Ò»ÆªÎÄÕ£¬½éÉÜ´óÈí¼þ¹«Ë¾ÃæÊÔʱ³£³£»á³öµÄÁ½µÀSQLÌ⣨¼û¸½Â¼£©¡£
ÎÒ¾õµÃÊÜÒæºÜ¶à£¬ÔÚ´Ë֮ǰ£¬ÎÒÒ»Ö±¾õµÃ£¬SQL2008ËƺõÌṩÁËÕâ·½ÃæµÄÖ§³Ö£¬µ«¸üµÍµÄ°æ±¾£¬°üÀ¨2005£¬·ÇÓαê×ö²»³öÀ´£¨Ë®Æ½¹»²Ë£©¡£×ܽáÐĵÃÈçÏ£º
1¡¢ Ç¿´óµÄgroup by
1 select stdname,
2 isnull( ......
ÎÄÕµ¼º½ SQL Server 2005 ѧϰ±Ê¼ÇϵÁÐÎÄÕµ¼º½
ÔÚSQl 2005 For XMl ¼òµ¥²éѯ(Raw£¬Auto£¬Pathģʽ)(1) ÀïÎÒÃÇ˵Á˹ØÓÚPath£¬RawºÍAutoģʽµÄÓ÷¨£¬ÆäʵÀïÃæ²»½ö½ö ÊÇÕâЩ¼òµ¥µÄ²Ù×÷£¬»¹ÓÐһЩÆäËüµÄÌØÐÔ£¬±ÈÈç˵Type»òOpenXml·½·¨£¬sp_xml_preparedocument´æ´¢¹ý³Ì µÈÕâЩÔö¼ÓµÄ¶«¶«£¬ÎÒÃÇÀ´Ò» ......
±¾ÎÄÀ´×Ô£ºhttp://www.cnblogs.com/digjim/archive/2006/09/20/509344.html
ÎÒÃÇÖªµÀ£¬SQL Server 2005ºÍSQL Server 2000 Ïà±È½Ï£¬SQL Server 2005ÓкܶàÐÂÌØÐÔ¡£ÕâƪÎÄÕÂÎÒÃÇÒªÌÖÂÛÆäÖеÄÒ»¸öк¯ÊýRow_Number()¡£Êý¾Ý¿â¹ÜÀíÔ±ºÍ¿ª·¢ÕßÒѾÆÚ´ýÕâ¸öº¯ÊýºÜ¾ÃÁË£¬ÏÖÔÚÖÕÓڵȵ½ÁË£¡
ͨ³££¬¿ª·¢Õߺ͹ÜÀíÔ±ÔÚÒ»¸ö ......
select pcode from (
select h.k,h.d,h.m,h.u,l.areacode,
l.areacode||substr(h.u,4,length(h.u))||h.k pcode
from(
&nb ......
Ëø¶¨Êý¾Ý¿âµÄÒ»¸ö±í
SELECT * from table WITH (HOLDLOCK)
×¢Òâ: Ëø¶¨Êý¾Ý¿âµÄÒ»¸ö±íµÄÇø±ð
SELECT * from table WITH (HOLDLOCK)
ÆäËûÊÂÎñ¿ÉÒÔ¶ÁÈ¡±í£¬µ«²»ÄܸüÐÂɾ³ý
SELECT * from table WITH (TABLOCKX)
ÆäËûÊÂÎñ²»ÄܶÁÈ¡±í,¸üкÍɾ³ý
SELECT Óï¾äÖГ¼ÓËøÑ¡ÏŦÄÜ˵Ã÷
SQL ServerÌṩÁËÇ¿´ó¶øÍ ......