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

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

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


Ïà¹ØÎĵµ£º

SQLÈÕÆÚת»»º¯Êý

--=======================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 ......

SQL¶¯Ì¬¼ÆËã³ö±íÖй«Ê½Ê¾Àý

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

SQLÈÕÆÚÀà´óÈ«£¨convert£©

---ÓÃ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 ) ......

°²×° SQL server2000ϵͳÌáʾÒÔǰµÄij¸öÎļþÒÔ¹ÒÆð

1¡¢¹ØÓÚSQL server 2000 ÔÚ°²×°¹ý³ÌÖÐÓöµ½Îļþ¹ÒÆðµÄ½â¾ö°ì·¨£º
ÔÚGhost °æ windows xp Öа²×° SQL server 2000 ʱ¾­³£»áÓöµ½°²×°³ÌÐòÔËÐе½µÚ¶þ²½£¨ÈçÏÂͼËùʾ£©Ê±µã»÷ÏÂÒ»²½ÏÔʾÓÐÎļþ¹ÒÆð²Ù×÷£¬ÌáÊ¾ÖØÐÂÆð
¶¯¼ÆËã»ú½â¾öÕâ¸öÎÊÌ⣬¿ÉÖØÐÂÆð¶¯¼ÆËã»úºó£¬°²×°³ÌÐò½øÐе½´ËÈÔÈ»ÏÔʾÓÐÎļþ¹ÒÆð²Ù×÷¡£Õâ¸öÎÊÌâµÄ²úÉúʵ¼Ê²¢ ......

SQL SERVER 2008 R2ÐÂÌØÐÔ

      ¿ÉÀ©Õ¹ÐԸĽø¡¡¡¡½èÖúÓÚÐÂÓ²¼þÉ豸¶ÔÓÚÆóÒµ°æWindows Server 2008 R2µÄÔöÇ¿£¬SQL Server2008R2½«ÄÜÖ§³Ö¸ß´ï56¸öÂß¼­´¦ÀíÆ÷ºÍ2TBÄÚ´æ¡£ÕâЩ¹¦ÄܵÄÔöÇ¿½«Ê¹µÃÆóÒµÄÜ´¦Àí¸ü¼Ó¾Þ´óµÄ¸ºÔØÁ¿£¬²¢ÄÜÔö¼Ó¿ÉÒÔͳһµ½Ò»¸öƽ̨ÉϵķþÎñÆ÷£¬ÊµÀýºÍÊý¾Ý¿âµÄÊýÁ¿¡£
¡¡¡¡ÕûºÏ¹¤¾ß
¡¡¡¡¶ÔÓÚSQLServer2008» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ