时间戳不带秒:
substring(replace(replace(replace(CONVERT(varchar, getdate(), 120 ),'-',''),' ',''),':',''),1,12 )
备份语句:
--创建存储过程
create proc [dbo].[backup_DB]
as
--定义变量
declare @filename varchar(100)
--变量赋值(将数据库备份到什么路径下)
select @filename =N'E:\db_backup\DB-'+convert(varchar(10),getdate(),120)+'.bak'
--备份数据库 battery_Liuh_0306为当前数据库
BACKUP DATABASE [battery_Liuh_0306] TO DISK = @filename
WITH NOFORMAT, NOINIT, NAME = N'PduBatteryManage-完整 数据库 备份',
SKIP, NOREWIND, NOUNLOAD, STATS = 10