Advertisement
SergioRP

Delete multiple values in while loop

Jun 29th, 2017
195
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.71 KB | None | 0 0
  1. DECLARE @i INT = 0
  2. WHILE @i < 30
  3. BEGIN
  4.     SET @i = @i + 1
  5.    
  6.     IF (@i < 10)
  7.         CONTINUE
  8.     ELSE
  9.         /* Deleta de Flairs-Thassia-10 atΓ© Flairs-Thassia-30 */
  10.         DELETE FROM [Flairs-Prod].[dbo].[EventoFotos]
  11.         WHERE [Nome] =
  12.             CONCAT(
  13.                 'Flairs-Thassia-',
  14.                 CONVERT(INT, CASE WHEN IsNumeric(CONVERT(VARCHAR(12), @i)) = 1 THEN CONVERT(VARCHAR(12), @i) ELSE 0 END)
  15.             )
  16.  
  17. END
  18.  
  19. DELETE FROM [Flairs-Prod].[dbo].[EventoFotos] WHERE [Nome] = 'Flairs-Thassia-08'
  20. DELETE FROM [Flairs-Prod].[dbo].[EventoFotos] WHERE [Nome] = 'Flairs-Thassia-09'
  21. DELETE FROM [Flairs-Prod].[dbo].[EventoFotos] WHERE [Nome] = 'Flairs-Natal-13'
  22. DELETE FROM [Flairs-Prod].[dbo].[EventoFotos] WHERE [Nome] = 'Flairs-Bruno-e-Marrone-04'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement