SQL数据库参数连接语句，转义

SQL数据库参数连接语句，转义

BACKUP DATABASE [UTU] TO  DISK = N'E:\ZT001\UTUBAK' WITH NOFORMAT, NOINIT,  NAME = N'UTU-完整 数据库 备份', SKIP, NOREWIND, NOUNLOAD, COMPRESSION,  STATS = 10

GO

备份数据库，用语句连接

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

declare @tp varchar(max)

declare @tbname varchar(50),@tb varchar(50)

set @tbname = 'UTU'+ CONVERT(VARCHAR(8),GETDATE(),112) + ''''

---------------------------- 20170317

print @tbname

set @tp = 'BACKUP DATABASE [UTU] TO  DISK = N''E:\ZT001\'+@tbname + ' WITH NOFORMAT, NOINIT,  NAME = N''UFMeta_001-完整 数据库 备份'', SKIP, NOREWIND, NOUNLOAD, COMPRESSION,  STATS = 10'

print @tp

exec(@tp)

GO