< DOCTYPE html PUBLIC -WCDTD XHTML StrictEN httpwwwworgTRxhtmlDTDxhtml-strictdtd>
declare @filename nvarchar(100)
set @filename='d:\\dbbak\\test+convert(char(10),getdate(),112)
print @filename
BACKUP DATABASE [test] TO DISK = @filename WITH NOINIT , NOUNLOAD , NAME = N'test 备份', NOSKIP , STATS = 10, NOFORMAT
set @filename='d:\\dbbak\\test+convert(char(10),getdate(),112)
print @filename
BACKUP DATABASE [test] TO DISK = @filename WITH NOINIT , NOUNLOAD , NAME = N'test 备份', NOSKIP , STATS = 10, NOFORMAT
本文转自 netcorner 博客园博客,原文链接:http://www.cnblogs.com/netcorner/archive/2007/10/26/2912272.html
,如需转载请自行联系原作者