SQL SERVER 2008 Õý³£°²×°Ê§°ÜºóµÄ¼¯³É°²×°
×î½üÐèÒª²âÊÔÒ»¸öÏîÄ¿, ÐèÒªSQL SERVER 2008, ÔÚ΢ÈíÏÂÔØÆÀ¹À°æºó½øÐа²×°
Öм䷢ÏÖÁËÖÖÖÖ°²×°Ê§°ÜµÄÎÊÌ⣬¶Ô¸Ã¹ý³Ì½øÐÐÁ˼Ǽ£¬Ï£Íû¸øÓöµ½´ËÀàÎÊÌâµÄÅóÓÑÃǹ²Í¬Ì½ÌÖ£¬ÓÐËù°ïÖú£º
1. WINDOWS 2003, WINDOWS 7 ÐÂ×°µÄʱºò¿ÉÐУ¬µ«ÊÇÈç¹ûÓÐɾ³ýºóÖØа²×°ÔòÎÞ·¨Ôٴΰ²×°
2. ¸ù¾ÝÍøÉÏÎÞÊýÏÈÇýµÄʧ°ÜÌáʾ£¬ ½øÐÐÁËÎÞÊýÖØÊÔ£¬°üÀ¨¸ü¸Ä°²×°ÎļþĿ¼£¬ÐÞ¸Ä×¢²á±íȨÏ޵Ⱦù²»Äܽâ¾ö
3. ²âÊÔÖÆ×÷¼¯³ÉSP1ºÍHOTFIX
Ê×ÏÈÏÂÔØÓйز¹¶¡
ÏÂÔØSQLServer2008SP1-KB968369-x86-CHS.exe
ÏÂÔØSQLServer2008SP1Ö®ºóµÄSP1µÄHOTFIX, ×¢ÒâÐèÒªÓÃÓʼþÊÕÈ¡½âѹÃÜÂ룬¿´À´Î¢ÈíÊÇÖÜÆڸı䲹¶¡µÄ½âѹÃÜÂ룬·ÀÖ¹ÓÐÈË×ö×Ô¶¯¸üÐÂ
4. ½âѹ
SQLServer2008SP1-KB968369-x86-CHS.exe /x:D:\SP1-PCU
SQLServer2008-KB969099-x86.exe /x:D:\SP1-CU
SQLServer2008-KB970315-x86.exe /x:D:\SP1-CU
SQLServer2008-KB973601-x86.exe /x:D:\SP1-CU
SQLServer2008-KB976761-x86.exe /x:D:\SP1-CU
5. ¼¯³É°²×°
Setup.exe /PCUSource=D:\SP1-PCU /CUSource=D:\SP1-CU
ÕâÒ»²½Ö´ÐÐʧ°Ü£¬ÌáʾÈçÏ´íÎó
Microsoft (R) SQL Server 2008
The following error occurred:
The setting 'PCUSOURCE' specified is not recognized.
Error result: -2068578301
Result facility code: 1204
Result error code: 3
Please review the summary.txt log for further details
¸ù¾ÝÏÈÇýµÄ¾Ñé ÏÈÖ´ÐнâѹºóµÄsqlsupport.msi£¬È»ºóÖØÐÂÖ´ÐÐ
ɾ³ý֮ǰ°²×°ÖУ¬´ýºóÐø...
ɾ³ýÒÅÁô°²×°»¨ÁË¿ìÒ»¸öСʱ
ÔÚÎÒµÄÀÏNBÉÏ×°ÁËÁ½¸ö¶à¸öСʱÁË£¬ÖÕÓÚ°²×°³É¹¦£¡
°²×°ºó²éѯһÏ°汾Ϊ Microsoft SQL Server 2008 (SP1) - 10.0.2740.0 (Intel X86) Oct 24 2009 15:53:40
Ïà¹ØÎĵµ£º
Sql Server ÓÐÈçϼ¸Ö־ۺϺ¯ÊýSUM¡¢AVG¡¢COUNT¡¢COUNT(*)¡¢MAX ºÍ MIN£¬µ«ÊÇÕâЩº¯Êý¶¼Ö»ÄܾۺÏÊýÖµÀàÐÍ£¬ÎÞ·¨¾ÛºÏ×Ö·û´®¡£Èçϱí:AggregationTable
Id Name
1 ÕÔ
2 Ç®
1 Ëï
1 Àî
2 ÖÜ
Èç¹ûÏëµÃµ½ÏÂͼµÄ¾ÛºÏ½á¹û
Id Name
1 ÕÔËïÀî
2 Ç®ÖÜ
ÀûÓÃSUM¡¢AVG¡¢COUNT¡¢COUNT(*)¡¢MAX ºÍ MINÊÇÎÞ·¨×öµ½µ ......
ÔÚÇÚÕÜEXCEL·þÎñÆ÷ÖÐÓÐ×óÓÒÄÚÁ¬½ÓµÄ²Ù×÷£¬ÎÒÃÇÔÚÕâÀïÓÃSQLÓï¾äÀ´Êµ¼Ê˵Ã÷Ò»ÏÂÖ®¼äµÄÇø±ðÓë×÷Óá£
= ÄÚÁ¬½Ó SQLÖÐΪinner join
*= ×óÁ¬½Ó °üº¬ËùÓеÄ×ó±ß±íÖеļǼÉõÖÁÊÇÓұ߱íÖÐûÓкÍËüÆ¥ÅäµÄ¼Ç¼¡£ SQLÖÐΪleft j ......
SQLÓï·¨ÓëÃüÁî
SELECT Óï¾ä
SELECT[predicate]{*|table.*|[table.]field [,[table.]field2[,...]]} [AS alias1
[,alias2[,...]]]
from tableexpression [,...][IN externaldatabase]
[WHERE...]
[GROUP BY...]
[HAVING...]
[ORDER BY...]
[WITH OWNERACCESS OPTION]
SELECT Óï¾ä°üÀ¨ÏÂÃ漸¸ö²¿·Ö
predicate
......
±¾ÎĽ«½éÉÜC#ÏîÄ¿´ò°üÒÔ¼°×Ô¶¯°²×°SQL SeverÊý¾Ý¿â£¬°üÀ¨´´½¨²¿ÊðÏîÄ¿¡¢½«Ö÷³ÌÐòÏîÄ¿µÄÊä³öÌí¼Óµ½²¿ÊðÏîÄ¿ÖС¢´´½¨°²×°³ÌÐòÀà¡¢´´½¨×Ô¶¨Òå°²×°¶Ô»°¿òµÈµÈ¡£
’power by: landlordh
’for 2000,xp,2003
Module uninstall
Sub Main ......
sqlÓï¾ä²éѯ½á¹ûºÏ²¢union ºÍunion allÓ÷¨
--ºÏ²¢Öظ´ÐÐ
select * from A
union
select * from B
--²»ºÏ²¢Öظ´ÐÐ
select * from A
union all
select * from B
°´Ä³¸ö×Ö¶ÎÅÅÐò
--ºÏ²¢Öظ´ÐÐ
select *
from (
select * from A
union
select * from B) AS T
order by ×Ö¶ÎÃû
--²»ºÏ²¢Öظ´ÐÐ
sel ......