Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @i INT = 0
- WHILE @i < 30
- BEGIN
- SET @i = @i + 1
- IF (@i < 10)
- CONTINUE
- ELSE
- /* Deleta de Flairs-Thassia-10 atΓ© Flairs-Thassia-30 */
- DELETE FROM [Flairs-Prod].[dbo].[EventoFotos]
- WHERE [Nome] =
- CONCAT(
- 'Flairs-Thassia-',
- CONVERT(INT, CASE WHEN IsNumeric(CONVERT(VARCHAR(12), @i)) = 1 THEN CONVERT(VARCHAR(12), @i) ELSE 0 END)
- )
- END
- DELETE FROM [Flairs-Prod].[dbo].[EventoFotos] WHERE [Nome] = 'Flairs-Thassia-08'
- DELETE FROM [Flairs-Prod].[dbo].[EventoFotos] WHERE [Nome] = 'Flairs-Thassia-09'
- DELETE FROM [Flairs-Prod].[dbo].[EventoFotos] WHERE [Nome] = 'Flairs-Natal-13'
- DELETE FROM [Flairs-Prod].[dbo].[EventoFotos] WHERE [Nome] = 'Flairs-Bruno-e-Marrone-04'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement