Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

WindowsÏÂÆô¶¯Í£Ö¹SQL Server 2005·þÎñ

ºÜ¶à¼¼Êõ°®ºÃÕߵĵçÄÔÉÏ×ÜÊÇ°²×°Á˺ܶàÈí¼þ£¬°üÀ¨Ó¦ÓÃÈí¼þ¡¢¿ª·¢¹¤¾ßÈí¼þ¼°Êý¾Ý¿âÈí¼þ£¬µ«ÊÇËæ×Åʱ¼äµÄÁ÷ÊÅ£¬ÂýÂýµØµçÄÔÉÏ×°µÄÈí¼þÒѾ­³¬³öÁ˵çÄÔ±¾ÉíËùÄÜ
³ÐÔصÄÁ¿ÁË£¬Òò¶ø³öÏÖÁ˵çÄÔÔËÐÐËÙ¶ÈÂýµÈÎÊÌ⡣ͬʱ£¬Ò²ÓÐһЩµ¥Î»»ò¸öÈ˵ĵçÄÔÓÉÓÚ³ö³§Äê´úÓÐЩ¾ÃÔ¶£¬¼´Ê¹Ö»°²×°Ò»ÖÖ»ò¼«ÉÙÊýÈí¼þʱҲ»áÏÔʾ³öÔËÐÐËÙ¶ÈÂý
µÄÏÖÏó¡£Èç¹ûÎÒÃDz¢²»ÊÇ̫Ƶ·±Ê¹ÓÃijЩÈí¼þ£¬ÎªÁ˼ӿì»úÆ÷µÄÔËÐÐÏìÓ¦Ëٶȣ¬ÎÒÃǾͻáÑ¡ÔñÔÝÍ£ÕâЩÈí¼þÏà¹ØµÄ·þÎñÒÔ¼õÇáÄÚ´æ¡¢CPUµÄ¸ºÔØ¡£ÏÂÃæÎÒÃǽ«
SQL Server 2005×÷Ϊһ¸öÀý×ÓÀ´½éÉÜһϡ£
         SQL
Server±¾ÉíÊÇÒ»¸öºÜÕ¼×ÊÔ´µÄÈí¼þ£¬¹âÒ»¸öʵÀý·þÎñËùÕ¼Äڴ棬¸ù¾ÝÆ䰲װʱ·ÖÅäµÄÄÚ´æ¾ÍÖÁÉÙÒª´ïµ½256MBÒÔÉÏ£¬ÔÙ¼ÓÉÏÆäËû¸½Êô·þÎñ£¬¹âÄÚ´æ¾ÍÒªÕ¼
ÓÃÎïÀíÄÚ´æµÄ20-30%×óÓÒ£¬ÖÁÓÚCPU£¬SQL ServerÒ²ÐèÒªÕ¼ÓÃ20%×óÓÒ£¬Òò¶ø£¬ÎÒÃÇ¿¼ÂÇÔÚÓÐÐèҪʹÓÃSQL
ServerʱÆôÓÃÆäÏà¹Ø·þÎñ£¬Æ½Ê±ÔòÍ£Ö¹¸Ã·þÎñ¡£
        ÎÒÃÇÄÃSQL Server
2005×÷ΪÀý×Ó¡£Ê×ÏÈÔÚ“¿ªÊ¼=¡µÔËÐДÖÐÊäÈë“services.msc”£¬°´»Ø³µ£¬½øÈë“·þÎñ”¿ØÖÆ̨£¬½«SQL Server (MSSQLSERVER)¡¢SQL Server Agent
(MSSQLSERVER)¡¢SQL Server Analysis Services
(MSSQLSERVER)¡¢
SQL Server FullText
Search (MSSQLSERVER)¡¢SQL Server Integration Services¡¢SQL Server
Reporting Services (MSSQLSERVER)
¼°
SQL
Server VSS Writer
·þÎñµÄÊôÐÔÖÐÆô¶¯ÀàÐÍÐÞ¸ÄΪ“ÊÖ¶¯
”£¬È»ºóÔÚÐèҪʹÓÃʱÆô¶¯SQL Server (MSSQLSERVER)¡¢SQL Server Analysis
Services (MSSQLSERVER)¡¢SQL Server FullText Search (MSSQLSERVER)¡¢SQL
Server Integration Services¡¢SQL Server Reporting Services (MSSQLSERVER)
¼°SQL Server VSS Writer
ÕâЩ·þÎñ£¬²»Ê¹ÓÃʱͣ
Ö¹£¬¶øÇÒÕâÑù×ö¼´Ê¹»úÆ÷¹Ø»ú»òÖØÆôºó£¬Ä¬ÈÏϵͳ»¹ÊDz»»áÆô¶¯ÕâЩ·þÎñµÄ¡£µ±È»ÎÒÃǽ¨Ò齫Æô¶¯Í£Ö¹·þÎñµÄ²Ù×÷дÔÚÒ»¸öÅú´¦ÀíÎļþÖз½±ãʹÓá£
         ÏÂÃæÎÒÃǸ½ÉÏÆô¶¯¼°Í£Ö¹SQL Server 2005·þÎñµÄÅú´¦ÀíÎļþÄÚÈÝ£¨¾ßÌåÅú´¦ÀíÎļþÇë¼û¸½¼þ£©£º
 
Æô¶¯SQL Server 2005·þÎñ£º
 
@echo off
@ ECHO Æô¶¯SQL Server 2005
·þÎñ
net start "SQL Server (MSSQLSERVER)"
net start "SQL Server
Analysis Servic


Ïà¹ØÎĵµ£º

PL/SQL¼¯½õ

--ÉèÖÃÊý¾Ý¿âÊä³ö£¬Ä¬ÈÏΪ¹Ø±Õ£¬Ã¿´Îдò¿ª´°¿Ú¶¼ÒªÖØÐÂÉèÖÃ
set serveroutput on
--µ÷Óà    °ü           º¯Êý    ²ÎÊý
execute dbms_output.put_line('hello world');
--»òÕßÓÃcallµ÷Óã¬Ï൱ÓÚjavaÖеĵ÷ÊÔ³ÌÐò´ò×®
call d ......

SQL Server 2005 ²»ÔÊÐíÔ¶³ÌÁ¬½Ó½â¾ö·½·¨

¸Õ¸Õ°²×°µÄÊý¾Ý¿âϵͳ£¬°´ÕÕĬÈÏ°²×°µÄ»°£¬ºÜ¿ÉÄÜÔÚ½øÐÐÔ¶³ÌÁ¬½Óʱ±¨´í£¬Í¨³£ÊÇ´íÎó:"ÔÚÁ¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Ëʧ°Ü¡£ (provider: ÃüÃû¹ÜµÀÌṩ³ÌÐò, error: 40 - ÎÞ·¨´ò¿ªµ½ SQL Server µÄÁ¬½Ó) "ËÑMSDN£¬ÉÏÃæÓÐһƬ»úÆ÷·­ÒëµÄÎÄÕ£¬ÊÇÔÚÈÃÈËÄÑÒÔÃ÷°×£¬ÏÖÔÚ ......

SQL Server Ë÷Òý½á¹¹¼°ÆäʹÓã¨Ò»£©

Ò»¡¢ÉîÈëdz³öÀí½âË÷Òý½á¹¹
¡¡¡¡Êµ¼ÊÉÏ£¬Äú¿ÉÒÔ°ÑË÷ÒýÀí½âΪһÖÖÌØÊâµÄĿ¼¡£Î¢ÈíµÄsql serverÌṩÁËÁ½ÖÖË÷Òý£º¾Û¼¯Ë÷Òý£¨clustered index£¬Ò²³Æ¾ÛÀàË÷Òý¡¢´Ø¼¯Ë÷Òý£©ºÍ·Ç¾Û¼¯Ë÷Òý£¨nonclustered index£¬Ò²³Æ·Ç¾ÛÀàË÷Òý¡¢·Ç´Ø¼¯Ë÷Òý£©¡£ÏÂÃ棬ÎÒÃǾÙÀýÀ´ËµÃ÷һϾۼ¯Ë÷ÒýºÍ·Ç¾Û¼¯Ë÷ÒýµÄÇø±ð£º
¡¡¡¡Æäʵ£¬ÎÒÃǵĺºÓï×ÖµäµÄÕ ......

SQLÓï¾ä»ã×Ü

SQL :Structured Query Language½á¹¹»¯²éѯÓïÑÔ
1.Select [Predicate] *(filed) from table/view Where ... Group by ... Having... Order by ... With ...
   Predicate£º°üÀ¨all/Distinct/Distinctrow/Top£¬ÏÞÖƲéѯ½á¹û£»
   As¿ÉÒÔÃüÃû±ðÃû£»
   Where ... Ö¸¶¨Ä³Ð©Ìõ¼þ£¬½«ËùÓ ......

´«ÖDz¥¿Í—SQLÈëÃÅ

½ñÌì¿ÉÒÔ»»»»ÄÔ×ÓÁË£¬¶ªµôeclipse£¬ÍæÍæsqlÁË£¬ËäȻֻÊÇÔÚÃüÁîÐд°¿Ú
ÏÈ˵һϽñÌìÎÒÓöµ½µÄÎÊÌâ°É£¬¿ªÊ¼°´ÕÕÀÏʦµÄ²¿Êð£¬×öµÄ¶¼ºÜ˳Àû£¬µ«Êǵ±½¨Á¢ºÃÊý¾Ý¿âÖ®ºó£¬½¨Á¢±í½á¹¹µÄʱºò¾Í³ö´íÁË£¬Ô­ÒòÊÇÔÚÅäÖÃmysqlµÄʱºò£¬È¨ÏÞÅäÖôíÁË£¬ËùÒÔ˵ǧÀïÖ®µÌ»ÙÓÚÒÏѨ£¬º¦µÄÎÒÕûÁËÒ»¸öÖÐÎ磬ÕâʱÌáʾµÄ´íÎóÊÇERROR 1005: Can't creat ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ