Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @s varchar(1000)
- SELECT @s = case
- WHEN
- ("Check some Settings")
- THEN
- 'BACKUP DATABASE [DB] TO DISK = ''C:SQL BackupBackup.dat'' WITH COMPRESSION, NOFORMAT, NOINIT, SKIP, REWIND, NOUNLOAD, STATS = 10'
- ELSE
- 'BACKUP DATABASE [DB] TO DISK = ''C:SQL BackupBackup.dat'' WITH NOFORMAT, NOINIT, SKIP, REWIND, NOUNLOAD, STATS = 10;'
- END
- EXEC (@s)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement