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
Ïà¹ØÎĵµ£º
--ÉèÖÃÊý¾Ý¿âÊä³ö£¬Ä¬ÈÏΪ¹Ø±Õ£¬Ã¿´Îдò¿ª´°¿Ú¶¼ÒªÖØÐÂÉèÖÃ
set serveroutput on
--µ÷Óà °ü º¯Êý ²ÎÊý
execute dbms_output.put_line('hello world');
--»òÕßÓÃcallµ÷Óã¬Ï൱ÓÚjavaÖеĵ÷ÊÔ³ÌÐò´ò×®
call d ......
¸Õ¸Õ°²×°µÄÊý¾Ý¿âϵͳ£¬°´ÕÕĬÈÏ°²×°µÄ»°£¬ºÜ¿ÉÄÜÔÚ½øÐÐÔ¶³ÌÁ¬½Óʱ±¨´í£¬Í¨³£ÊÇ´íÎó:"ÔÚÁ¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Ëʧ°Ü¡£ (provider: ÃüÃû¹ÜµÀÌṩ³ÌÐò, error: 40 - ÎÞ·¨´ò¿ªµ½ SQL Server µÄÁ¬½Ó) "ËÑMSDN£¬ÉÏÃæÓÐһƬ»úÆ÷·ÒëµÄÎÄÕ£¬ÊÇÔÚÈÃÈËÄÑÒÔÃ÷°×£¬ÏÖÔÚ ......
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 ... Ö¸¶¨Ä³Ð©Ìõ¼þ£¬½«ËùÓ ......
Ò»¡¢»ù´¡
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname
3¡¢ËµÃ÷£º±¸·Ýsql server
--- ´´½¨ ±¸·ÝÊý¾ÝµÄ device
USE master
EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1.dat'
--- ¿ªÊ¼ ±¸·Ý
BACKUP DATABASE pubs TO testBack
4¡¢Ëµ ......
½éÉÜ
ͨ³££¬Ñз¢ÈËԱʹÓõÄÊÇT-SQLÀ´´´½¨SQL ServerµÄ´æ´¢¹ý³Ì¡¢º¯ÊýºÍ´¥·¢Æ÷¡£ ¶øÏÖÔÚµÄSQL Server 2005ÒÑÍêÈ«Ö§³Ö.NETͨÓÃÓïÑÔÔËÐÐʱ£¨CLR£©ÁË¡£ Õâ¾ÍÒâζ×Å£¬ÄúÄܹ»Ê¹ÓÃ.NETµÄÓïÑÔ£¬ÈçC#¡¢VB.NETÖ®ÀàµÄÀ´Ñз¢SQL ServerµÄ´æ´¢¹ý³Ì¡¢º¯ÊýºÍ´¥·¢Æ÷¡£ SQL Server ºÍ CLR µÄ¼¯³É¸øÎÒÃÇ´øÀ´ÁËn¶àºÃ´¦£¬Èçʵʱ±àÒë¡¢ÀàÐÍ°²È«¡ ......