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

ÁíÀà¼òµ¥µÄSQLÊý¾Ý¿â¸ÄÃû·½·¨

°ÑOldÊý¾Ý¿â¸ÄΪNewÊý¾Ý¿â
1.´ò¿ª“ÆóÒµ¹ÜÀíÆ÷”ÕÒµ½ OldÊý¾Ý¿â£­£­¡·ÓÒ¼ü£­£­¡·ËùÓÐÈÎÎñ£­£­¡··ÖÀëÊý¾Ý¿â
2.µ½C:\Program Files\Microsoft SQL Server\MSSQL\DataÏÂÕÒµ½Old_Data.mdfºÍOld_log.ldf°ÑOld_Data»»³ÉÄãÏëÒªµÄÃû×ÖÀýÈçNew.mdf¡¢New.ldf
3.µ½ÆóÒµ¹ÜÀíÆ÷£¬ÕÒµ½ Êý¾Ý¿â £­£­¡·ÓÒ¼ü£­£­¡·ËùÓÐÈÎÎñ£­£­¡·¸½¼ÓÊý¾Ý¿â£­£­¡·ÔÚµ¯³öµÄ¶Ô»°¿òÀïÕÒµ½¸Õ²ÅÄã¸ÄÃûµÄÎļþNew.mdf
ÕâʱÄú¿ÉÒÔ¿´µ½“Ô­Êý¾Ý¿âÎļþÃû”“µ±Ç°ÎļþλÖÔ£¬ÔÚ“µ±Ç°ÎļþλÖÔǰ»áÓдóºìX£¬È»ºóÊÖ¶¯Ð޸ēµ±Ç°ÎļþλÖԵķ¾¶ÀïµÄÎļþÃû£¬¸ÄΪNew.MDF,New.LDF,´óºìXÏûʧ£¬“ÔÚ¸½¼ÓΪ£º”Àï±ßдÉÏÄãÏëʹÓõÄÊý¾Ý¿âÃûNew,"Ö¸¶¨Êý¾Ý¿âËùÓÐÕߣº"ÀïдÉÏÕâ¸öÊý¾Ý¿âµÄËùÓÐÕß¡£
4.ËäÈ»ÏÖÔÚµÄÊý¾Ý¿âÎļþÃûÏÔʾµÄÊÇÎÒÃÇÏëÒªµÄ“New”,µ«´ËʱµÄÂß¼­ÎļþÃû»¹Ã»ÓÐÐ޸ģ¬»¹ÊÇÔ­À´µÄÄǸö“Old_Data”£¬¹¤¾ß£­£­¡·SQL ²éѯ·ÖÎöÆ÷£­£­¡·È»ºóÊäÈ룺
Alter DataBASE New
MODIFY FILE(NAME='Old_Data',NEWNAME='New_Data')
Alter DataBASE New
MODIFY FILE(NAME='Old_Log',NEWNAME='New_Log')
£­£­¡·°´F5ÔËÐбã¿É¡£
´ó¹¦¸æ³É


Ïà¹ØÎĵµ£º

SQL Server×Ô´ø±¸·ÝÕû¸öÊý¾Ý¿â½Å±¾¹¤¾ß scptxfr.exe


Ê×ÏÈÔÚsqlserverµÄ°²×°Â·¾¶Ï£¬È磺D:\Program Files\Microsoft SQL
Server\MSSQL\£¬ÕÒµ½ÎļþÃûÊÇscptxfr.exeµÄÎļþ,ÀûÓÃÃüÁîÐй¤¾ß£º¾ßÌåÓ÷¨ÈçÏ£º
D:\PROGRA~1\MICROS~2\MSSQL\>scptxfr/?
ÃüÁîÐÐÓï·¨:
SCPTXFR /s
<·þÎñÆ÷> /d <Êý¾Ý¿â> {[/I] | [/P <ÃÜÂë>]}
    &n ......

½â¾öSQL ËÀËøµÄÓï¾ä

ALTER     procedure [dbo].[sp_lock_check]
@spid1 int = NULL,               
@spid2 int = NULL               
as
set nocount on
if @spid1 is not NULL
begin
        select ......

SQLÓï¾äµÄÓÅ»¯ÒÔ¼°Ë÷ÒýµÄÓ¦Ó÷¶Î§

SQLÓÅ»¯µÄÔ­ÔòÊÇ£º½«Ò»´Î²Ù×÷ÐèÒª¶ÁÈ¡µÄBLOCKÊý¼õµ½×îµÍ¡£
µ÷Õû²»Á¼SQLͨ³£¿ÉÒÔ´ÓÒÔϼ¸µãÇÐÈ룺
¼ì²é²»Á¼µÄSQL£¬¿¼ÂÇÆäд·¨ÊÇ·ñ»¹ÓпÉÓÅ»¯ÄÚÈÝ£»
¼ì²é×Ó²éѯ¿¼ÂÇSQL×Ó²éѯÊÇ·ñ¿ÉÒÔÓüòµ¥Á¬½ÓµÄ·½Ê½½øÐÐÖØÐÂÊéд£»
¼ì²éÓÅ»¯Ë÷ÒýµÄʹÓã»
¿¼ÂÇÊý¾Ý¿âµÄÓÅ»¯Æ÷;
²éѯµÄÒ»°ã¹æÔò
Ø      ......

Sql server ʱ¼ä¶Î²éѯ µÄÏà¹Ø·Ñ½âÎÊÌâ

sql server ʱ¼ä¶Î²éѯ¡£
==========================================
select g.borrowTime  from t_apartment_goodsborrow g
where g.borrowTime >= '2010-03-11 9:50:43'
2010-03-11 9:52:54
----------------------------------------------------------------------------
select g.borrowTime  ......

sqlº¯Êý¡¡

1¡¢ISNULL ( check_expression , replacement_value )
²ÎÊý
check_expression
½«±»¼ì²éÊÇ·ñΪ NULLµÄ±í´ïʽ¡£check_expression ¿ÉÒÔÊÇÈκÎÀàÐ͵ġ£
replacement_valueÔÚ check_expressionΪNULLʱ½«·µ»ØµÄ±í´ïʽ¡£replacement_value ±ØÐëÓë check_expresssion ¾ßÓÐÏàͬµÄÀàÐÍ¡£
·µ»ØÀàÐÍ
·µ»ØÓë check_expression Ï ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ