ÁíÀà¼òµ¥µÄ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ÔËÐбã¿É¡£
´ó¹¦¸æ³É
Ïà¹ØÎĵµ£º
http://inthirties.com:90/thread-1202-1-1.html
v$sqltext
´æ´¢µÄÊÇÍêÕûµÄSQL,SQL±»·Ö¸î
SQL> desc v$sqltext
Name Null? Type
----------------------------------------- -------- ----------------------------
ADDRESS ......
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[pagination]
@tblName varchar(255), -- ±íÃû
@strGetFields varchar(1000), -- ÐèÒª·µ»ØµÄÁÐ
@fldName varchar(255), -- ÅÅÐòµÄ×Ö¶ÎÃû
@PageSize int, -- Ò³³ß´ç
@PageIndex int, -- Ò³Âë
@OrderType bit, -- ÉèÖÃÅÅÐòÀàÐÍ, ·Ç 0 Öµ ......
½ñÌìºÜÓôÃÆ,ʵÑéÊҵķþÎñÆ÷¶«Î÷¶¼Ã»ÓÐÁË,¶øÎÒµÄÊý¾Ý¿âÓÖÔÚÄÄÀï,ÎÒÓÖûÓб¸·Ý,°ÑÎÒÒÖÓôµÄÒªÃü,ÐÒ¿÷ÎÒÓõÄlinq to sql.×ÐϸÏëÏë,ËûµÄdbmlÎļþ»ù±¾°üº¬ÁËÊý¾Ý¿âµÄËùÓÐÄÚÈÝ,ËùÒÔ,Ò»¶¨Óа취´ÓdbmlÎļþÖд´½¨Êý¾Ý¿â!
Ñо¿ÁËÒ»¶ÎÊ ......
´ËΪתÌù£¬µ«ÊÇ´ÓÁ¬¸öÌû×ÓÖÐÊÕ¼¯¶øÀ´
ÏÂÃæÀ´Ò»Æð¿´¿´ÂÛ̳ÀïµÄÒ»¸öoracle·½ÃæµÄÎÊÌ⣺
====================Question
=========================
jmbdat dayt y &n ......