SQL Server 2005ÍêȫжÔØ
SQL Server 2005µÄжÔØÊÇÒ»¸ö·Ç³£Í·ÌÛµÄÎÊÌâ¡£ÎÒÔø¾³¢ÊÔ¹ýÖ±½ÓʹÓá¾Ìí¼Ó»òɾ³ý³ÌÐò¡¿¹¤¾ßжÔØ¡¢Çå³ý°²×°Ä¿Â¼¡¢É¾³ý×¢²á±íÄÚÈݵȵȸ÷ÖÖ·½Ê½×ÛºÏжÔØ£¬ÃãÇ¿³É¹¦¡£ÏÖÔÚÖÕÓÚÕÒµ½ÁËÒ»¸öÊ°빦±¶µÄ·½·¨£¬¶à´Î³¢ÊÔ£¬Î´ÓÐʧ°Ü,¾ßÌåÈçÏÂ:
1.ÏÂÔØжÔع¤¾ß£¬ÓÐÁ½ÖÖ£º
µÚÒ»ÖÖÊÇ΢Èí¹Ù·½ÌṩµÄ¹¤¾ß(msicuu2.exe)
http://support.microsoft.com/default.aspx?kbid=290301
µÚ¶þÖÖÊǸ÷´óÏÂÔØÍøÕ¾ÏÂÔصķÇ΢Èí¹Ù·½¹¤¾ß(SrvInstw.exe)
΢Èí¹Ù·½¹¤¾ßÐèÒª°²×°£¬¶øÇÒ°²×°²½Öè±È½ÏÂé·³£¬»¹ÓÐûÕÒµ½Ö§³Ö64λµÄ£»
·Ç΢Èí¹Ù·½¹¤¾ß´¿ÂÌÉ«£¬²»Ðè°²×°£¬Ö±½ÓжÔØ£¬Ö§³Ö64λ¡£
±¾È˾õµÃ΢Èí×Ô´øµÄ±È½Ï·½±ã£¬¿ÉÒÔÅúÁ¿Ñ¡Ôñ²¢Ð¶ÔØ£¬Ò²ËƺõжÔصĸü³¹µ×
2.ʹÓÃжÔع¤¾ßжÔØËùÓÐSQL Server·þÎñºÍÏà¹Ø×é¼þ(×¢Ò⣺жÔØÇ°ÒªÏÈÍ£Ö¹¶ÔÓ¦µÄ·þÎñ£¬·ñÔò¿ÉÄÜжÔØʧ°Ü)
3.ɾ³ýC:\WINDOWS\inf ÏÂËùÓÃÎļþ(ÎÒÊÇÔÚ¸ÃÎļþ¼ÐÏÂËÑË÷“sqlserver”£¬È»ºóɾ³ýËùÓнá¹ûÎļþ)
4.ɾ³ýsql 2005°²×°Ä¿Â¼ÏµÄËùÓÐÎļþ
5.ɾ³ý×¢²á±íÖÐ Microsoft Sql Server ½Ú
6.ʹÓÿØÖÆÃæ°åµÄ¡¾Ìí¼Ó»òɾ³ý³ÌÐò¡¿¹¤¾ß£¬²é¿´ÓÐÎÞÆäËûδɾ³ýµÄSQL Server³ÌÐò£¬ÈçÓж¼Ò»²¢É¾³ýµô
7.ÖØÆô¼ÆËã»ú
¼ÆËã»úÖØÆôÍê³Éºó£¬SQL Server 2005¾Í±»ÍêÈ«µÄжÔظɾ»ÁË£¬¿ÉÒÔÕý³£ÖØа²×°¡£
Ïà¹ØÎĵµ£º
select sql_text, spid, v$session.program, process
from v$sqltext, v$session, v$process
where v$sqltext.address = v$session.sql_address
and v$sqltext.hash_value = v$session.sql_hash_value
and v$session.paddr = v$process.addr
and v$process.spid in (4335);
×¢Ò ......
Èç¹ûÔÚSQL Server ÀïÐèÒª¶¨Ê±»òÕßÿ¸ôÒ»¶Îʱ¼äÖ´ÐÐij¸ö´æ´¢¹ý³Ì»ò3200×Ö·ûÒÔÄÚµÄSQLÓï¾äʱ, ¿ÉÒÔÓùÜÀí->SQL Server´úÀí->×÷ÒµÀ´ÊµÏÖ¡£
¡¡¡¡1¡¢¹ÜÀí->SQL Server´úÀí->×÷Òµ(°´Êó±êÓÒ¼ü)->н¨×÷Òµ
¡¡¡¡2¡¢Ð½¨×÷ÒµÊôÐÔ(³£¹æ)->Ãû³Æ[×Ô¶¨Òå±¾´Î×÷ÒµµÄÃû³Æ]->ÆôÓõķ½¿òÄÚÊǹ´ºÅ->
·ÖÀà´¦¿ ......
1. GROUP BY ÊÇ·Ö×é²éѯ, Ò»°ã GROUP BY ÊǺ;ۺϺ¯ÊýÅäºÏʹÓÃ
group by ÓÐÒ»¸öÔÔò,¾ÍÊÇ select ºóÃæµÄËùÓÐÁÐÖÐ,ûÓÐʹÓþۺϺ¯ÊýµÄÁÐ,±ØÐë³öÏÖÔÚ group by ºóÃ棨ÖØÒª£©
ÀýÈç,ÓÐÈçÏÂÊý¾Ý¿â±í£º
A B
1 abc
1 bcd
1 asdfg
Èç¹ûÓÐÈ ......
oracleµÄodbcÍø¹Ø£¨gateway£©¼¸ºõÌṩһ¸öÎÞÏßµÄÊý¾ÝÕûºÏƽ̨£¬ÔÚoracleºÍÆäËüRDBMSÖ®¼ä£¬ÎÒÔÚÕâ²»Ïë˵ËüµÄ£¬²Ù×÷£¬ÏÞÖÆÒÔ¼°Ïà¹ØÐÔ£¬Ëü½â¾öÁËÒ»¸öСÎÊÌ⣬°ÑËü½¨Á¢ÆðÀ´ÄãÄÜ£¬ÀýÈ磬´´½¨Ò»¸ö database link ÔÚoracle ºÍoracleÖ®¼ä£¬±Ï¾¹£¬ÕâÑù²»ÊǺܺÃô£¬ÀýÈçÄãÄÜÔËÐÐÏÂÃæµÄsqlÓï¾ä£¬
select o.col1, m.col1 from or ......