quete sql c4

-- trustworth to on
ALTER DATABASE SuperMoney
    SET trustworth = ON;

COMMIT;

-- BACKUP DATABASE
USE SuperMoney;
GO;
BACKUP DATABASE SuperMoney
TO DISK = '/Users/helenamiura/Projects/Net/37-queteSQL'
   WITH FORMAT,
      MEDIANAME = 'SQLSuperMoneyBackup',
      NAME = 'Full Backup of SuperMoney';
GO;



BEGIN TRANSACTION;

-- delete user 'hack3r'
DELETE
    FROM logs
    WHERE [user] = 'hack3r';

-- delete the 3 first
DELETE TOP(3)
    FROM logs;

COMMIT;