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

±¸·Ý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ÎļþÀҲ¿ÉÒÔÒÔ´æ´¢¹ý³Ì·½Ê½ÊµÏÖ¡£


Ïà¹ØÎĵµ£º

SQLSERVER SQLÐÔÄÜÓÅ»¯

1.Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)¡¡¡¡
¡¡¡¡ SQLSERVERµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬Òò´Ëfrom×Ó¾äÖÐдÔÚ×îºóµÄ±í£¨»ù´¡±ídriving table£©½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏ£¬±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í£¬µ±SQLSERVER´¦Àí¶à¸ö±íʱ£¬»áÔËÓÃÅÅÐò¼°ºÏ²¢µÄ·½Ê½Á ......

sql serverÖеĴ洢¹ý³Ìµ÷ÊÔ

µ÷ÊÔ:
ÔÚSQL QUERYÖЗ¡·¶ÔÏóä¯ÀÀÆ÷—¡·´æ´¢¹ý³Ì—¡·Ñ¡ÔñÒªµ÷ÊԵĴ洢¹ý³Ì—¡·ÓÒ»÷—¡·Ñ¡Ôñµ÷ÊÔ£¨debug£©—¡·ÊäÈë²ÎÊý—¡·--ÉèÖÃÍêÄãµÄ²ÎÊýÖµºó--µã»÷Ö´ÐУ¬¾ÍÊdzöÏÖÒ»¸ö¸¡¶¯¹¤¾ßÌõ£¬ÉÏÃæÓе¥²½Ö´ÐУ¬¶ÏµãÉèÖõÈ
---¸ú×Ù :
¿ªÊ¼->³ÌÐò->MS SQLSERVER->ʼþ̽²éÆ÷(SQL Prof ......

sqlÀàÐÍת»»º¯ÊýcastºÍconvert

¼ò½é£º
        Êý¾ÝÀàÐÍת»»¿ÉÒÔͨ¹ýCAST()ºÍCONVERT()º¯ÊýÀ´ÊµÏÖ¡£´ó¶àÊýÇé¿öÏ£¬ÕâÁ½¸öº¯ÊýÊÇÖØµþµÄ£¬ËüÃÇ·´Ó³ÁËSQLÓïÑÔµÄÑÝ»¯ÀúÊ·¡£ÕâÁ½¸öº¯ÊýµÄ¹¦ÄÜÏàËÆ£¬²»¹ýËüÃǵÄÓï·¨²»Í¬¡£ËäÈ»²¢·ÇËùÓÐÀàÐ͵ÄÖµ¶¼ÄÜת±äΪÆäËûÊý¾ÝÀàÐÍ£¬µ«×ܵÄÀ´Ëµ£¬ÈκοÉÒÔת»»µÄÖµ¶¼¿ÉÒÔÓüòµ¥µÄº¯ÊýʵÏÖ× ......

SQL Server 2000 Êý¾Ýͬ²½¹ý³Ì

SQL Server
2000¶©ÔÄÓë·¢²¼µÄ¾ßÌå²Ù×÷
ͬ²½¹ý³Ì
¡¡¡¡Ò»¡¢×¼±¸¹¤×÷£¬Èç¹ûÍê³ÉÔò¿ÉÌø¹ý¡£
¡¡¡¡1¡¢ÄÚÍøDB·þÎñÆ÷×÷Ϊ·¢²¼·þÎñÆ÷£¬ÍâÍøDB·þÎñÆ÷×÷Ϊ¶©ÔÄ·þÎñÆ÷¡£
¡¡¡¡·¢²¼·þÎñÆ÷ºÍ¶©ÔÄ·þÎñÆ÷ÉϷֱ𴴽¨WindowsÓû§jl,ÃÜÂëjl£¬Á¥ÊôÓÚadministrators£¬×¢ÒâÒª±£³ÖÒ»Ö¡£
¡¡¡¡2¡¢·¢²¼·þÎñÆ÷ÉÏ´´½¨Ò»¸ö¹²ÏíĿ¼£¬×÷Ϊ·¢²¼¿ìÕÕÎ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ