Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @i INT = 0
- DECLARE @v VARCHAR(MAX)
- WHILE @i < 6
- BEGIN
- SET @i = @i + 1
- IF (@i < 10)
- SET @v = FORMAT (@i, '0#')
- ELSE
- SET @v = CONVERT(INT, CASE WHEN IsNumeric(CONVERT(VARCHAR(12), @i)) = 1 THEN CONVERT(VARCHAR(12), @i) ELSE 0 END)
- INSERT INTO [Flairs-Prod].[dbo].[EventoFotos]
- ([EventoId],
- [Nome],
- [Path],
- [TipoArquivo],
- [CreationTime],
- [Ordem])
- VALUES
- (18,
- CONCAT('Flairs-Aniversario-Trigemeos-', @v),
- CONCAT('/Assets/Site/images/eventos/07/flairs-aniversario-trigemeos-', @v, '.jpg'),
- 'foto',
- '2017-06-29',
- @i + 2)
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement