ÁíÀà¼òµ¥µÄ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ÔËÐбã¿É¡£
´ó¹¦¸æ³É
Ïà¹ØÎĵµ£º
1¡¢SessionÓÐʲôÖØ´óBUG£¬Î¢ÈíÌá³öÁËʲô·½·¨¼ÓÒÔ½â¾ö£¿
´ð£ºÊÇiisÖÐÓÉÓÚÓнø³Ì»ØÊÕ»úÖÆ£¬ÏµÍ³·±Ã¦µÄ»°Session»á¶ªÊ§£¬¿ÉÒÔÓÃSate server»òSQL ServerÊý¾Ý
¿âµÄ·½Ê½´æ´¢Session²»¹ýÕâÖÖ·½Ê½±È½ÏÂý£¬¶øÇÒÎÞ·¨²¶»ñSessionµÄENDʼþ¡£
2.²úÉúÒ»¸öintÊý×飬³¤¶ÈΪ100£¬²¢ÏòÆäÖÐËæ»ú²åÈë1-100£¬²¢ÇÒ²»ÄÜÖظ´¡£
C# ......
1. ¼òÊö private¡¢ protected¡¢ public¡¢ internal ÐÞÊηûµÄ·ÃÎÊȨÏÞ¡£
´ð . private : ˽ÓгÉÔ±, ÔÚÀàµÄÄÚ²¿²Å¿ÉÒÔ·ÃÎÊ¡£
protected : ±£»¤³ÉÔ±£¬¸ÃÀàÄÚ²¿ºÍ¼Ì³ÐÀàÖпÉÒÔ·ÃÎÊ¡£
public : ¹«¹²³ÉÔ±£¬ÍêÈ«¹«¿ª£¬Ã»ÓзÃÎÊÏÞÖÆ¡£
internal: ÔÚÍ¬Ò ......
sql serverÖÐÈçºÎÅжϱí»òÕßÊý¾Ý¿âµÄ´æÔÚ£¬µ«ÔÚʵ¼ÊʹÓÃÖУ¬ÐèÅжÏStatus״̬λ£º
ÆäÖÐijЩ״̬λ¿ÉÓÉÓû§Ê¹Óà sp_dboption£¨read only¡¢dbo use only¡¢single user µÈ£©½øÐÐÉèÖãº
1 = autoclose£»Ê¹Óà sp_dboption ÉèÖᣠÊý¾Ý¿âÍêÈ«¹Ø±Õ£¬Æä×ÊÔ´ÔÚ×îºóÒ»¸öÓû§×¢ÏúºóÊÍ·Å¡£
4 = select into/bulkcopy£»Ê¹Óà sp_dbopti ......
Select * from t_user_profile where convert ( varchar ( 21 ),regDate, 120 ) like ' 2008-05-07% ' ±íÃû³Æ£ºt_user_profile ÈÕÆÚ×Ö¶ÎÃû³Æ£ºregDate
Select * from t_user_profile where convert(varchar(21),regDate,120) like '2008-05-07%'< ......
1¡¢ISNULL ( check_expression , replacement_value )
²ÎÊý
check_expression
½«±»¼ì²éÊÇ·ñΪ NULLµÄ±í´ïʽ¡£check_expression ¿ÉÒÔÊÇÈκÎÀàÐ͵ġ£
replacement_valueÔÚ check_expressionΪNULLʱ½«·µ»ØµÄ±í´ïʽ¡£replacement_value ±ØÐëÓë check_expresssion ¾ßÓÐÏàͬµÄÀàÐÍ¡£
·µ»ØÀàÐÍ
·µ»ØÓë check_expression Ï ......