Advertisement
Guest User

Untitled

a guest
Sep 3rd, 2015
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. DECLARE @s varchar(1000)
  2. SELECT @s = case
  3. WHEN
  4. ("Check some Settings")
  5. THEN
  6. 'BACKUP DATABASE [DB] TO DISK = ''C:SQL BackupBackup.dat'' WITH COMPRESSION, NOFORMAT, NOINIT, SKIP, REWIND, NOUNLOAD, STATS = 10'
  7. ELSE
  8. 'BACKUP DATABASE [DB] TO DISK = ''C:SQL BackupBackup.dat'' WITH NOFORMAT, NOINIT, SKIP, REWIND, NOUNLOAD, STATS = 10;'
  9. END
  10. EXEC (@s)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement