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

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)
  


Ïà¹ØÎĵµ£º

SQLÒ»¸ö´æ´¢¹ý³Ìµ÷ÓÃÁíÒ»¸ö´æ´¢¹ý³Ì »ñµÃ·µ»ØÖµÎÊÌâ

µÚÒ»ÖÖ·½·¨: ʹÓÃoutput²ÎÊý
USE AdventureWorks;
GO
IF OBJECT_ID ( 'Production.usp_GetList', 'P' ) IS NOT NULL
    DROP PROCEDURE Production.usp_GetList;
GO
CREATE PROCEDURE Production.usp_GetList @product varchar(40)
    , @maxprice money
    , ......

sqlÊä³ö9*9³Ë·¨¿Ú¾÷±í

--------------·½·¨A-----------------
³ÌÐò:
declare
    i int:=1;
    v varchar2(200):=NULL;
    v1 varchar2(20):=NULL;
begin
    loop
        for k in 1..i loop
            v1:=k||' ......

½â¾öͬʱÐÞ¸ÄͬһSQL¼Ç¼µÄÎÊÌâ

ÔÚÑ°ÕÒPowerDesignerÏà¹ØÐÅÏ¢µÄʱºòżȻ·¢ÏÖµÄ.ʹÓÃtimestamp
΢ÈíMSDNÄÚÈÝ:
timestamp (Transact-SQL)
¹«¿ªÊý¾Ý¿âÖÐ×Ô¶¯Éú³ÉµÄΨһ¶þ½øÖÆÊý×ÖµÄÊý¾ÝÀàÐÍ¡£timestamp ͨ³£ÓÃ×÷¸ø±íÐмӰ汾´ÁµÄ»úÖÆ¡£ ´æ´¢´óСΪ 8 ¸ö×Ö½Ú¡£ timestamp Êý¾ÝÀàÐÍÖ»ÊǵÝÔöµÄÊý×Ö£¬²»±£ÁôÈÕÆÚ»òʱ¼ä¡£ ÈôÒª¼Ç¼ÈÕÆÚ»òʱ¼ä£¬ÇëʹÓà datetime ......

Ìá¸ßSQLÖ´ÐÐЧÂʵļ¸µã½¨Òé

Ìá¸ßSQLÖ´ÐÐЧÂʵļ¸µã½¨Òé:
¡¡¡¡¡ô¾¡Á¿²»ÒªÔÚwhereÖаüº¬×Ó²éѯ;
¡¡¡¡¹ØÓÚʱ¼äµÄ²éѯ£¬¾¡Á¿²»ÒªÐ´³É£ºwhere to_char(dif_date,'yyyy-mm-dd')=to_char('2007-07-01','yyyy-mm-dd');
¡¡¡¡¡ôÔÚ¹ýÂËÌõ¼þÖУ¬¿ÉÒÔ¹ýÂ˵ô×î´óÊýÁ¿¼Ç¼µÄÌõ¼þ±ØÐë·ÅÔÚwhere×Ó¾äµÄĩβ;
¡¡¡¡from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í£¬driving table)½«±»× ......

SQL²éѯÖظ´Êý¾ÝºÍÇå³ýÖظ´Êý¾Ý


ÓÐÀý±í£ºemp
emp_no   name    age    
    001           Tom      17    
    002       &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ