on error resume next
dtmYesterday1 = Date
dtmYesterday = Date-4
strYear1 = Year(dtmYesterday1)
strYear = Year(dtmYesterday)
strMonth1 = Month(dtmYesterday1)
strMonth = Month(dtmYesterday)
strDay1 = Day(dtmYesterday1)
strDay = Day(dtmYesterday)

If Len(strMonth1) = 1 Then 
    strMonth1 = "0" & strMonth1
End If 

If Len(strMonth) = 1 Then 
    strMonth = "0" & strMonth 
End If

If Len(strDay1) = 1 Then 
    strDay1 = "0" & strDay1 
End If

If Len(strDay) =

--exec   master..xp_cmdshell   'net   use   Q:   \\共享文件夹   "密码"   /user:IP用户名'  --映射网络硬盘

--exec   master..xp_cmdshell   'net   use   Q:   /delete' --删除网络硬盘

第二步 ：写存储过程

CREATE PROCEDURE [nikko_backup] AS

declare

@prefix nvarchar(100),

@datefile nvarchar(100),

@datefile1 nvarchar(100),

@bakfile nvarchar(100),

@rarfile nvarchar(100),