DECLARE
@SQLExec varchar(MAX) SET @SQLExec = NULL SELECT @SQLExec = COALESCE (@SQLeXEC + ''', DISK = ', '') + '''' + BackupFileName FROM PublishDetails WITH (NOLOCK) WHERE databasename = 'DWStage' Print @SQLExec
@SQLExec varchar(MAX) SET @SQLExec = NULL SELECT @SQLExec = COALESCE (@SQLeXEC + ''', DISK = ', '') + '''' + BackupFileName FROM PublishDetails WITH (NOLOCK) WHERE databasename = 'DWStage' Print @SQLExec
No comments:
Post a Comment