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

´ò¿ªSqlÊý¾Ý¿âÎļþ£¨À©Õ¹ÃûΪmdf£©

ºó׺ÃûΪ.mdfµÄsqlÊý¾Ý¿âÈçºÎ´ò¿ª£¿
ÓÐ.mdfºÍ.ldfÁ½¸öÎļþ£¬´ò¿ª·½°¸£º
·½·¨Ò»£ºÔÚSql serverÆóÒµ¹ÜÀíÆ÷ÖÐ   -   Êý¾Ý¿â   - ÓÒ¼ü <¸½¼ÓÊý¾Ý¿â
 ·½·¨¶þ£ºÔÚVS2005ÖÐÏȽ¨Á¢Ò»¸öÓëÄãÒª´ò¿ªµÄmdfÎļþͬÃûµÄÊý¾Ý¿â£¬¼Çס´æ´¢Î»Öã¬È»ºóÓÃÄãÒª´ò¿ªµÄmdfÎļþ½«¸Õ½¨Á¢µÄmdfÊý¾Ý¿âÎļþÌæ»»¼´¿É¡£


Ïà¹ØÎĵµ£º

sql ÐÔÄܵ÷Õû

1. Ñ¡ÓÃÊʺϵÄORACLEÓÅ»¯Æ÷
   ORACLEµÄÓÅ»¯Æ÷¹²ÓÐ3ÖÖ:
   a.  RULE (»ùÓÚ¹æÔò)   b. COST (»ùÓڳɱ¾)  c. CHOOSE (Ñ¡ÔñÐÔ)
   ÉèÖÃȱʡµÄÓÅ»¯Æ÷,¿ÉÒÔͨ¹ý¶Ôinit.oraÎļþÖÐOPTIMIZER_MODE²ÎÊýµÄ¸÷ÖÖÉùÃ÷,ÈçRULE,COST,CHOOSE,ALL_ROWS,FIRST_ROWS . Ä㵱ȻҲÔÚSQL¾ä¼ ......

SQL SERVER2008 ÏÂÔØµØÖ·¼°ÐòÁкÅ

SQL Server 2008¼òÌåÖÐÎÄÆóÒµ°æÏÂÔØ£º
thunder://QUFodHRwOi8vd3d3LnF1aWNrOC5jbi9kb3duLmFzcD9pZD0xMjM2JnNpZD0wWlo=
±¾DVD°üº¬ÁËx86 x64 ia64 ÈýÖÖCPUģʽµÄ°²×°³ÌÐò¡£°æ±¾ºÅΪ£º 10.0.1600.22
ÐòÁкţº
¿ª·¢°æ(Developer): PTTFM-X467G-P7RH2-3Q6CG-4DMYB
ÆóÒµ°æ(Enterprise): JD8Y6-HQG69-P9H84-XDTPG-34MBB ......

Sqlʱ¼äº¯Êý

Sqlʱ¼äº¯Êý
Ò»¡¢sql serverÈÕÆÚʱ¼äº¯Êý
Sql ServerÖеÄÈÕÆÚÓëʱ¼äº¯Êý 
1.  µ±Ç°ÏµÍ³ÈÕÆÚ¡¢Ê±¼ä 
    select getdate()  
2. dateadd  ÔÚÏòÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¶Îʱ¼äµÄ»ù´¡ÉÏ£¬·µ»ØÐµĠdatetime Öµ
   Àý ......

ʹÓÃ×Ô¶¨Òå±íÀàÐÍ£¨SQL Server 2008£©

##################################################
#        ÉùÃ÷£º
#        ±¾ÎÄת×ÔCSDN£¬Óû§ID£ºhtl258
#        Ô­ÌûµØÖ·£ºhttp://blog.csdn.net/htl258/archive/2010/04/28/5537432.aspx
####### ......

SQL Server 2008ÖеıíÖµÐͲÎÊý

##################################################
#        ÉùÃ÷£º
#        ±¾ÎÄת×ÔCSDN£¬Óû§ID£ºhtl258
#        Ô­ÌûµØÖ·£ºhttp://blog.csdn.net/htl258/archive/2010/04/28/5537416.aspx
####### ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ