Home Forums SQL Server 2008 T-SQL (SS2K8) String manipulation with variable RE: String manipulation with variable

  • November 24, 2012 at 7:27 pm

    #1562016

    You can do this in this way.

    Declare @Datestamp as varchar(10)

    SET @Datestamp=Convert(varchar(8),getdate(),112)

    EXEC('BACKUP DATABASE [ReportServer]

    TO DISK = ''D:\MSSQL\BAK\ReportServer'+ @Datestamp+'.BAK''

    WITH FORMAT, COMPRESSION')