SQL ServerÖ®×é¼þ»®·Ö
´Ó²»Í¬µÄ½Ç¶È£¬ÎÒÃÇ¿ÉÒÔ°ÑSQL ServerÊý¾Ýƽ̨»®·ÖΪ¶à¸ö×é¼þ¡£ÎÒÃÇÏÂÃæ°´ÕÕSQL Server Internal Teamͨ³£µÄ»®·ÖÔÔò£¬°ÑSQL ServerÊý¾Ýƽ̨»®·ÖΪÈçÏ£º
SSAS: SQL Server Analysis Service¡£Ö÷ÒªÓÃÀ´×ö·ÖÎöÓ㬱ÈÈçCube£¬¿ÉÒÔ´Ó²»Í¬µÄ½Ç¶ÈÉóÊÓÊý¾Ý¡£
SSIS: SQL Server Integration Service¡£±ÈÈçExcelÊý¾ÝºÍÊý¾Ý¿âÊý¾ÝµÄ»¥²Ù×÷¡£
SSRS: SQL Server Reporting Service¡£Ö÷ÒªÓÃÀ´×öBI,×ö±¨±í¡£
Engine: SQL Server Engine¡£Êý¾Ý¿âµÄÒýÇ棬·Ç³£ÖØÒª£¬ºÃ±ÈÈ˵ÄÐÄÔàÒ»Ñù¡£
MPU: SQL ServerÊý¾Ý¿âµÄÍâΧ£¬±ÈÈçInstall,Uninstall,Upgrade,RepairµÈµÈ¡£
ÉÏÊö5´ó×é¼þ¹¹³ÉÁËÕû¸öSQL ServerÊý¾Ýƽ̨¡£ÓÉÓÚSQL Server Engine ÌرðÖØÒª£¬ÎÒÃÇÓÖ¿ÉÒÔ°ÑËü»®·ÖΪÈçϵÄComponents:
AM: Access Method¡£±È½Ïµ×²ã£¬Ö÷ÒªÓÃÀ´´æ´¢Êý¾Ý¡£
TS: Transaction Service¡£ÊÂÎñ£¬Ò»ÇÐÊÂÎñÊý¾Ý¿âµÄ»ù´¡¡£
FS: Filestream¡£SQL Server 2008µÄÐÂÔö¹¦ÄÜ£¬Ö÷ÒªÓÃÀ´´æ´¢>2GµÄÊý¾Ýµ½NTFS Driver¡£
QE: Query Execution¡£Ö÷Òª¸ºÔðSQL Óï¾äµÄÖ´ÐС£
QP: Query Process¡£Ö÷ÒªÓÃÀ´´¦ÀíÓû§IssueµÄSQLÓï¾ä£¬±ÈÈçT-SQLÓï¾äµÄÓÅ»¯£¬Ö´Ðмƻ®¡£
SQLOS: SQL Operation System¡£SQL Server 2008µÄÐÂÔö×é¼þ£¬ÎªÁË¿ØÖÆÊý¾Ý¿â¸ü¼ÓÁé»î£¬ÎªÖ®¿ª·¢ÁËÒ»¸öµ¥¶ÀµÄOS²ã¡£
Programmability£ºÖ÷ÒªÓÃÀ´¸ºÔðºÍVSµÈ±à³Ìƽ̨µÄÏνÓÒÔ¼°SQL±à³Ì£¬±ÈÈçAssembly£¬Óα꣬´æ´¢¹ý³Ì£¬´¥·¢Æ÷µÈµÈ¡£
XML£ºÓÃÀ´²Ù×÷XMLÊý¾Ý¡£
Replication£ºÓÃÀ´½øÐÐÊý¾ÝµÄ¸´ÖÆ£¬¸´ÖÆÊÇÊý¾Ý¿âµÄÒ»¸ö±È½ÏÓÐÓõŦÄÜ¡£
FullText£ºÓÃÀ´×öÈ«ÎÄË÷Òý¡£
SSB: SQL Server Service Broker£ºÒ»¸öµ×²ãµÄ×é¼þ£¬·Ç³£ÓÐÓã¬ÓÃÀ´±£³ÖͨѶµÄÒ»ÖÂÐÔ¡£
¶ÔÓÚÒÔÉÏEngineµÄ11¸öComponentsÖУ¬AM,TS,FS¹¹³ÉÁËSQL Server Storage Engine¡£ÖÁÓÚÿ¸ö×é¼þµÄ¹¦ÄÜ£¬ÎÒ»áÔÚÒÔºóµÄBlogÖнøÐÐÏêϸµÄÃèÊö£¬ÕâƪÎÄÕÂÖ÷ÒªÊÇÒ»¸ö´ó¸Å¡£
ÕâÀïÓм¸±¾Êé¿ÉÒÔ¹©´ó¼Ò²Î¿¼£º
Inside SQL Server 2000
Inside-MsSql2K5-SE (Inside Microsoft SQL Server 2005 Storage Engine)
Inside-MsSql2K5-P (Inside Microsoft SQL Server 2005 Programming)
Inside-MsSql2K5-TSql (Inside Microsoft SQL Server 2005 T-SQL Querying)
Inside-MsSql2K5-QTO (Inside Microsoft SQL Server 2005 Query Tuning and Optimization)
Ïà¹ØÎĵµ£º
±¾ÏµÁÐÎÄÕµ¼º½
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Ò»)--αÁÐROWNUMʹÓü¼ÇÉ
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(¶þ)--±êÁ¿×Ó²éѯ
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Èý)--PackageµÄÓŵã
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(ËÄ)--ÅúÁ¿´¦Àí
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Îå)--µ÷Óô洢¹ý³Ì·µ»Ø½á¹û¼¯
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Áù)- ......
ʹÓþۼ¯Ë÷ÒýÓÅ»¯SQL²éѯ
Ê×ÏÈÈÃÎÒÃÇ×öÒ»¸ö²âÊÔ£¬ÏÖ´´½¨Ò»¸ö±í Ïò±íÖвåÈë²»µÈÊý¾Ý
--DROP TABLE T_UserInfo--------------------------------------
CREATE
TABLE
T_UserInfo
(
Userid
varchar(20),
UserName varchar(20)
)
--
DECLARE
@I INT
DECLARE
@ENDID INT
SELECT
@I =
1
SELECT
@ ......
## ɾ³ýÊý¾Ý¿â
drop database ecport;
## ´´½¨Êý¾Ý¿â
create database ecport;
## ʹÓÃÊý¾Ý¿â
use ecport;
## ¹ú¼Ò±í½á¹¹
create table COUNTRY(
&nbs ......
from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í£¬driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏ£¬Äã±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í¡£
¡¡¡¡Ìá¸ßSQLÖ´ÐÐЧÂʵļ¸µã½¨Òé:
¡¡¡¡¡ô¾¡Á¿²»ÒªÔÚwhereÖаüº¬×Ó²éѯ;
¡¡¡¡¹ØÓÚʱ¼äµÄ²éѯ£¬¾¡Á¿²»ÒªÐ´³É£ºwhere to_char(dif_date,'yyyy-mm-dd')=to_char('2007-07-01',' ......
select 1 from ...£¬ sqlÓï¾äÖеÄ1´ú±íʲôÒâ˼£¿²é³öÀ´ÊǸöʲô½á¹û£¿
select 1 from table;Óëselect anycol(Ä¿µÄ±í¼¯ºÏÖеÄÈÎÒâÒ»ÐУ© from table;Óëselect * from table ´Ó×÷ÓÃÉÏÀ´ËµÊÇûÓвî±ðµÄ£¬¶¼ÊDz鿴ÊÇ·ñÓмǼ£¬Ò»°ãÊÇ×÷Ìõ¼þ²éѯÓõġ£select 1 from Ö ......