´ò¿ªSqlÊý¾Ý¿âÎļþ£¨À©Õ¹ÃûΪmdf£©
ºó׺ÃûΪ.mdfµÄsqlÊý¾Ý¿âÈçºÎ´ò¿ª£¿
ÓÐ.mdfºÍ.ldfÁ½¸öÎļþ£¬´ò¿ª·½°¸£º
·½·¨Ò»£ºÔÚSql serverÆóÒµ¹ÜÀíÆ÷ÖÐ - Êý¾Ý¿â - ÓÒ¼ü <¸½¼ÓÊý¾Ý¿â
·½·¨¶þ£ºÔÚVS2005ÖÐÏȽ¨Á¢Ò»¸öÓëÄãÒª´ò¿ªµÄmdfÎļþͬÃûµÄÊý¾Ý¿â£¬¼Çס´æ´¢Î»Öã¬È»ºóÓÃÄãÒª´ò¿ªµÄmdfÎļþ½«¸Õ½¨Á¢µÄmdfÊý¾Ý¿âÎļþÌæ»»¼´¿É¡£
Ïà¹ØÎĵµ£º
--=======================CONVERT()==================================================
Select CONVERT(varchar(100), GETDATE(), 0)--: 05 16 2006 10:57AM
Select CONVERT(varchar(100), GETDATE(), 1)--: 05/16/06
Select CONVERT(varchar(100), GETDATE(), 2)--: 06.05.16
Select CONVERT(varchar(100), GETDATE ......
##################################################
# ÉùÃ÷£º
# ±¾ÎÄת×ÔCSDN£¬Óû§ID£ºhtl258
# ÔÌûµØÖ·£ºhttp://blog.csdn.net/htl258/archive/2010/05/13/5588454.aspx
####### ......
---ÓÃconvertת»»²ÎÊý¶Ô±È
select CONVERT(varchar, getdate(), 120 )
2004-09-12 11:06:08
select replace(replace(replace(CONVERT(varchar, getdate(), 120 ),'-',''),' ',''),':','')
20040912110608
select CONVERT(varchar(12) , getdate(), 111 )
2004/09/12
select CONVERT(varchar(12) , getdate(), 112 )
......
1¡¢¹ØÓÚSQL server 2000 ÔÚ°²×°¹ý³ÌÖÐÓöµ½Îļþ¹ÒÆðµÄ½â¾ö°ì·¨£º
ÔÚGhost °æ windows xp Öа²×° SQL server 2000 ʱ¾³£»áÓöµ½°²×°³ÌÐòÔËÐе½µÚ¶þ²½£¨ÈçÏÂͼËùʾ£©Ê±µã»÷ÏÂÒ»²½ÏÔʾÓÐÎļþ¹ÒÆð²Ù×÷£¬ÌáÊ¾ÖØÐÂÆð
¶¯¼ÆËã»ú½â¾öÕâ¸öÎÊÌ⣬¿ÉÖØÐÂÆð¶¯¼ÆËã»úºó£¬°²×°³ÌÐò½øÐе½´ËÈÔÈ»ÏÔʾÓÐÎļþ¹ÒÆð²Ù×÷¡£Õâ¸öÎÊÌâµÄ²úÉúʵ¼Ê²¢ ......
¿ÉÀ©Õ¹ÐԸĽø¡¡¡¡½èÖúÓÚÐÂÓ²¼þÉ豸¶ÔÓÚÆóÒµ°æWindows Server 2008 R2µÄÔöÇ¿£¬SQL Server2008R2½«ÄÜÖ§³Ö¸ß´ï56¸öÂß¼´¦ÀíÆ÷ºÍ2TBÄÚ´æ¡£ÕâЩ¹¦ÄܵÄÔöÇ¿½«Ê¹µÃÆóÒµÄÜ´¦Àí¸ü¼Ó¾Þ´óµÄ¸ºÔØÁ¿£¬²¢ÄÜÔö¼Ó¿ÉÒÔͳһµ½Ò»¸öƽ̨ÉϵķþÎñÆ÷£¬ÊµÀýºÍÊý¾Ý¿âµÄÊýÁ¿¡£
¡¡¡¡ÕûºÏ¹¤¾ß
¡¡¡¡¶ÔÓÚSQLServer2008» ......