Advertisement
Guest User

Untitled

a guest
Oct 17th, 2018
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.78 KB | None | 0 0
  1. IF NOT EXISTS (SELECT * FROM [dbo].[Backup.Model.Storages] WHERE [object_id] = @object_id AND [backup_id] = @backup_id)
  2.         BEGIN
  3.             SELECT KEYS.[id] INTO #ArchiveKeys
  4.             FROM [dbo].[CryptoKeys] AS KEYS
  5.             JOIN [dbo].[CryptoKeys.ArchiveRecs] AS archiveRecs ON archiveRecs.[archive_key_id] = KEYS.[id]
  6.             WHERE KEYS.[backup_id] = @backup_id AND archiveRecs.[object_id] = @object_id
  7.  
  8.             DECLARE @archiveKeyId UNIQUEIDENTIFIER
  9.             DECLARE archiveKeyCur CURSOR FOR SELECT id FROM #ArchiveKeys
  10.             OPEN archiveKeyCur
  11.        
  12.                 FETCH NEXT FROM archiveKeyCur INTO @archiveKeyId
  13.            
  14.                 WHILE @@FETCH_STATUS = 0
  15.                 BEGIN
  16.                     EXEC [DeleteCryptoKey] @archiveKeyId, @usn;
  17.                     FETCH NEXT FROM archiveKeyCur INTO @archiveKeyId
  18.                 END
  19.  
  20.             CLOSE archiveKeyCur    
  21.             DEALLOCATE archiveKeyCur
  22.         END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement