´ò¿ªSqlÊý¾Ý¿âÎļþ£¨À©Õ¹ÃûΪmdf£©
ºó׺ÃûΪ.mdfµÄsqlÊý¾Ý¿âÈçºÎ´ò¿ª£¿
ÓÐ.mdfºÍ.ldfÁ½¸öÎļþ£¬´ò¿ª·½°¸£º
·½·¨Ò»£ºÔÚSql serverÆóÒµ¹ÜÀíÆ÷ÖÐ - Êý¾Ý¿â - ÓÒ¼ü <¸½¼ÓÊý¾Ý¿â
·½·¨¶þ£ºÔÚVS2005ÖÐÏȽ¨Á¢Ò»¸öÓëÄãÒª´ò¿ªµÄmdfÎļþͬÃûµÄÊý¾Ý¿â£¬¼Çס´æ´¢Î»Öã¬È»ºóÓÃÄãÒª´ò¿ªµÄmdfÎļþ½«¸Õ½¨Á¢µÄmdfÊý¾Ý¿âÎļþÌæ»»¼´¿É¡£
Ïà¹ØÎĵµ£º
Sqlʱ¼äº¯Êý
Ò»¡¢sql serverÈÕÆÚʱ¼äº¯Êý
Sql ServerÖеÄÈÕÆÚÓëʱ¼äº¯Êý
1. µ±Ç°ÏµÍ³ÈÕÆÚ¡¢Ê±¼ä
select getdate()
2. dateadd ÔÚÏòÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¶Îʱ¼äµÄ»ù´¡ÉÏ£¬·µ»ØÐ嵀 datetime Öµ
Àý ......
sqlͳ¼Æ£¹ØÓÚѧÉú³É¼¨(´ð°¸)
http://blog.sina.com.cn/s/blog_61380b320100ej9p.html
´ð°¸£º
1. ¼ÆËãÿ¸öÈ˵Ä×ܳɼ¨²¢ÅÅÃû
select name,sum(score) as allscore from stuscore group by name order by allscore
2. &nbs ......
ǰ¶Îʱ¼äѧµÄÓйØsqlµÄÏà¹ØÖªÊ¶,ºÜ¶à¶¼Ã»¼°Ê±È¥ÕûÀí,½ñÌì¸ÕºÃÓÐʱ¼äÓÐûÐÄÇé×öÆäËûµÄÊÇ,¾ÍÕûÀíÕûÀí°É
Ò»Ö±ÒÔΪ×ö¿ª·¢µÄ¶ÔÊý¾Ý¿â²Ù×÷·½ÃæµÄÒªÇó²»»áºÜ¸ß,Ö»Òª»á¶ÔÊý¾ÝÔöɾ¸Ä²é¾ÍokÁË.ÏÖÔÚ²ÅÖªµÀ¶ÔÊý¾Ý¿âµÄ²Ù×÷»¹Ó¦¸Ã°üÀ¨Ð´´æ´¢ºÍº¯Êý,»¹Òª´´½¨ÐòÁС¢Ë÷Òý,ÊÓͼµÈ.
......
¿ÉÀ©Õ¹ÐԸĽø¡¡¡¡½èÖúÓÚÐÂÓ²¼þÉ豸¶ÔÓÚÆóÒµ°æWindows Server 2008 R2µÄÔöÇ¿£¬SQL Server2008R2½«ÄÜÖ§³Ö¸ß´ï56¸öÂß¼´¦ÀíÆ÷ºÍ2TBÄÚ´æ¡£ÕâЩ¹¦ÄܵÄÔöÇ¿½«Ê¹µÃÆóÒµÄÜ´¦Àí¸ü¼Ó¾Þ´óµÄ¸ºÔØÁ¿£¬²¢ÄÜÔö¼Ó¿ÉÒÔͳһµ½Ò»¸öƽ̨ÉϵķþÎñÆ÷£¬ÊµÀýºÍÊý¾Ý¿âµÄÊýÁ¿¡£
¡¡¡¡ÕûºÏ¹¤¾ß
¡¡¡¡¶ÔÓÚSQLServer2008» ......