±¸·ÝSQL Server 2005Êý¾Ý¿âµ½Ö¸¶¨Ä¿Â¼µÄSQL½Å±¾
IF EXISTS (SELECT name from master.dbo.sysdatabases WHERE name = N'MyDatabase')
DECLARE @backupdate varchar(255);
DECLARE @result int
DECLARE @result1 int
DECLARE @dbid uniqueidentifier
SET @dbid = NEWID()
EXEC @result = xp_cmdshell 'cd D:\SQLServerBackups';
IF (@result = 1)
EXEC @result1 = xp_cmdshell 'MKDIR D:\SQLServerBackups';
if (@result1=0)
set @backupdate = 'D:\SQLServerBackups\'
+ cast(Year(getdate()) as char(4))
+ '-'+cast(Month(getdate()) as char(2))
+ '-'+cast(Day(getdate()) as char(2))
+ '-'+ cast(@dbid as varchar(50))
+ '-MyDatabase.bak';
BACKUP DATABASE MyDatabase
TO DISK = @backupdate WITH FORMAT;
--Drop database MyDatabase;
GO
--±¸·ÝMyDatabaseÊý¾Ý¿â
--ÓÃÔÚÖÆ×÷°²×°³ÌÐòµ÷ÓõÄSQLÎļþÀҲ¿ÉÒÔÒÔ´æ´¢¹ý³Ì·½Ê½ÊµÏÖ¡£
Ïà¹ØÎĵµ£º
1.Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)¡¡¡¡
¡¡¡¡ SQLSERVERµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬Òò´Ëfrom×Ó¾äÖÐдÔÚ×îºóµÄ±í£¨»ù´¡±ídriving table£©½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏ£¬±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í£¬µ±SQLSERVER´¦Àí¶à¸ö±íʱ£¬»áÔËÓÃÅÅÐò¼°ºÏ²¢µÄ·½Ê½Á ......
µ÷ÊÔ:
ÔÚSQL QUERYÖЗ¡·¶ÔÏóä¯ÀÀÆ÷—¡·´æ´¢¹ý³Ì—¡·Ñ¡ÔñÒªµ÷ÊԵĴ洢¹ý³Ì—¡·ÓÒ»÷—¡·Ñ¡Ôñµ÷ÊÔ£¨debug£©—¡·ÊäÈë²ÎÊý—¡·--ÉèÖÃÍêÄãµÄ²ÎÊýÖµºó--µã»÷Ö´ÐУ¬¾ÍÊdzöÏÖÒ»¸ö¸¡¶¯¹¤¾ßÌõ£¬ÉÏÃæÓе¥²½Ö´ÐУ¬¶ÏµãÉèÖõÈ
---¸ú×Ù :
¿ªÊ¼->³ÌÐò->MS SQLSERVER->ʼþ̽²éÆ÷(SQL Prof ......
¼ò½é£º
Êý¾ÝÀàÐÍת»»¿ÉÒÔͨ¹ýCAST()ºÍCONVERT()º¯ÊýÀ´ÊµÏÖ¡£´ó¶àÊýÇé¿öÏ£¬ÕâÁ½¸öº¯ÊýÊÇÖØµþµÄ£¬ËüÃÇ·´Ó³ÁËSQLÓïÑÔµÄÑÝ»¯ÀúÊ·¡£ÕâÁ½¸öº¯ÊýµÄ¹¦ÄÜÏàËÆ£¬²»¹ýËüÃǵÄÓï·¨²»Í¬¡£ËäÈ»²¢·ÇËùÓÐÀàÐ͵ÄÖµ¶¼ÄÜת±äΪÆäËûÊý¾ÝÀàÐÍ£¬µ«×ܵÄÀ´Ëµ£¬ÈκοÉÒÔת»»µÄÖµ¶¼¿ÉÒÔÓüòµ¥µÄº¯ÊýʵÏÖ× ......
SQL Server
2000¶©ÔÄÓë·¢²¼µÄ¾ßÌå²Ù×÷
ͬ²½¹ý³Ì
¡¡¡¡Ò»¡¢×¼±¸¹¤×÷£¬Èç¹ûÍê³ÉÔò¿ÉÌø¹ý¡£
¡¡¡¡1¡¢ÄÚÍøDB·þÎñÆ÷×÷Ϊ·¢²¼·þÎñÆ÷£¬ÍâÍøDB·þÎñÆ÷×÷Ϊ¶©ÔÄ·þÎñÆ÷¡£
¡¡¡¡·¢²¼·þÎñÆ÷ºÍ¶©ÔÄ·þÎñÆ÷ÉϷֱ𴴽¨WindowsÓû§jl,ÃÜÂëjl£¬Á¥ÊôÓÚadministrators£¬×¢ÒâÒª±£³ÖÒ»Ö¡£
¡¡¡¡2¡¢·¢²¼·þÎñÆ÷ÉÏ´´½¨Ò»¸ö¹²ÏíĿ¼£¬×÷Ϊ·¢²¼¿ìÕÕÎ ......