摘要:ALTER proc [P_DBBACKUP](@DbName varchar(50))asDECLARE @dbPath VARCHAR(200)select @dbPath='E:\bak\'select @dbPath=@dbPath+@DbName+'_'+convert(varchar(20),getdate(),112)+replace(convert(varchar(20),getdate(),108),':','')+'.bak'BACKUP DATABASE @DbName TO DISK = @
阅读全文
posted @ 2011-05-15 09:50