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

SQL Server ѹËõÈÕÖ¾¿Õ¼ä

ʹÓÃÁËÒ»¶Îʱ¼äºó£¬SQL Server µÄ LDFÎļþÌå»ý¾Þ´ó.
ÈçºÎ´¦ÀíàÏ, ¶ÔÓÚ SQL Server 2005 ¼°Ö®Ç°µÄ°æ±¾£¬¿ÉÒÔʹÓÃÈçÏ SQL£º
declare @name varchar(50)
set @name='dbname
'
backup
log @name
with truncate_only
dbcc shrinkdatabase (@name,20)
¿ÉÊÇÔÚ SQL Server 2008 ¿ªÊ¼£¬Ö´ÐÐÉÏÃæµÄÓï¾ä»á±¨´í:
'truncate_only' is not a recognized BACKUP option.
ËùÒª»»Ò»ÖÖ·½Ê½:
Ê×ÏÈÒªÓÒ¼ü DB ÊôÐÔÖÐÉèÖà Option µÄ Recovery model Ϊ Simple,
ÔÙÖ´ÐÐÈçÏ SQL (ºì×Ö²¿·ÖÌæ»»³Éʵ¼ÊµÄ Files µÄÈÕÖ¾ÎļþµÄ Âß¼­Ãû³Æ(Logical Name))
DBCC SHRINKFILE (N'agsr_log
' , 1)
GO
Ö´ÐÐÍêºó£¬ldf Îļþ±ä³É 1M µÄÄÚÈÝ.


Ïà¹ØÎĵµ£º

SQL SERVERÔÚ´æ´¢¹ý³ÌÖÐÁ¬½ÓÆäËûÊý¾Ý¿â

 --·ÃÎʲ»Í¬µçÄÔÉϵÄÊý¾Ý¿â    
  --Èç¹û¾­³£·ÃÎÊ»òÊý¾ÝÁ¿´ó,½¨ÒéÓÃÁ´½Ó·þÎñÆ÷  
   
  --´´½¨Á´½Ó·þÎñÆ÷  
  exec   sp_addlinkedserver     'srv_lnk','','SQLOLEDB','Ô¶³Ì·þÎñ ......

SQL ¶ÔDateTime (ʱ¼äºÍÈÕÆÚ£©Êý¾ÝÀàÐ͵Ļù±¾²Ù×÷

ÈÕÆÚºÍʱ¼äº¯Êý¶Ô½¨Á¢Ò»¸öÕ¾µãÊǷdz£ÓÐÓõġ£Õ¾µãµÄÖ÷ÈËÍùÍù¶ÔÒ»¸ö±íÖеÄÊý¾ÝºÎʱ±»
¸üиÐÐËȤ¡£Í¨¹ýÈÕÆÚºÍʱ¼äº¯Êý£¬Äã¿ÉÒÔÔÚºÁÃë¼¶¸ú×ÙÒ»¸ö±íµÄ¸Ä±ä¡£
·µ»Øµ±Ç°ÈÕÆÚºÍʱ¼ä
ͨ¹ýº¯ÊýGETDATE£¨£©£¬Äã¿ÉÒÔ»ñµÃµ±Ç°µÄÈÕÆÚºÍʱ¼ä¡£ÀýÈ磬Óï¾äSELECT GETDATE()
·µ»ØÈçϵĽá¹û£º
…………&h ......

sql CHARINDEXº¯Êý

sql CHARINDEXº¯Êý
SQL Server 2010-01-15 09:01:15 ÔĶÁ888 ÆÀÂÛ0 ×ֺţº´óÖÐС
CHARINDEXº¯Êý·µ»Ø×Ö·û»òÕß×Ö·û´®ÔÚÁíÒ»¸ö×Ö·û´®ÖÐµÄÆðʼλÖá£CHARINDEXº¯Êýµ÷Ó÷½·¨ÈçÏ£º
       CHARINDEX ( expression1 , expression2 [ , start_location ] )
      ......

SQL ServerÖÐÁÙʱ±íÓë±í±äÁ¿µÄÇø±ð

ÎÒÃÇÔÚÊý¾Ý¿âÖÐʹÓñíµÄʱºò,¾­³£»áÓöµ½Á½ÖÖʹÓñíµÄ·½·¨,·Ö±ð¾ÍÊÇʹÓÃÁÙʱ±í¼°±í±äÁ¿¡£ÔÚʵ¼ÊʹÓõÄʱºò£¬ÎÒÃÇÈçºÎÁé»îµÄÔÚ´æ´¢¹ý³ÌÖÐÔËÓÃËüÃÇ£¬ËäÈ»ËüÃÇʵÏֵŦÄÜ»ù±¾ÉÏÊÇÒ»ÑùµÄ£¬¿ÉÈçºÎÔÚÒ»¸ö´æ´¢¹ý³ÌÖÐÓÐʱºòȥʹÓÃÁÙʱ±í¶ø²»Ê¹Óñí±äÁ¿£¬ÓÐʱºòȥʹÓñí±äÁ¿¶ø²»Ê¹ÓÃÁÙʱ±íÄØ?
¡¡¡¡ÁÙʱ±í
¡¡¡¡ÁÙʱ±íÓëÓÀ¾Ã±íÏàËÆ£ ......

SQL SERVER 2008 ±Ê¼ÇÖ®ÐÐѹËõºÍҳѹËõ

 
/*
    2008 ѹËõ
 
 
    ÐÐѹËõ
   
    SQL SERVER 2008 Òý½øÁËÐÐѹËõÕâ¸öÐÂÌØÐÔ,Ö»ÓÐÆóÒµ°æ¾ßÓиÃÐÂÌØÐÔ.ÐÐѹËõÖ»ÐèÒª×îµÍµÄ¿Õ¼ä¶ÔÐÐÊý¾Ý½øÐÐѹËõ.ÐÐѹËõ¿ÉÒÔÔÚCREATEÒ»¸ö±í,Ë÷Òý»òÕßALTERÒ»¸ö±í,Ë÷ÒýµÄʱºò½øÐд´½¨.ѹËõ¿ÉÒÔÔÚ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ