Advertisement
SergioRP

Insert multiple values sql

Jun 29th, 2017
168
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.62 KB | None | 0 0
  1. DECLARE @i INT = 0
  2. DECLARE @v VARCHAR(MAX)
  3.  
  4. WHILE @i < 6
  5. BEGIN
  6.     SET @i = @i + 1
  7.    
  8.     IF (@i < 10)
  9.         SET @v = FORMAT (@i, '0#')
  10.     ELSE
  11.         SET @v = CONVERT(INT, CASE WHEN IsNumeric(CONVERT(VARCHAR(12), @i)) = 1 THEN CONVERT(VARCHAR(12), @i) ELSE 0 END)
  12.  
  13.     INSERT INTO [Flairs-Prod].[dbo].[EventoFotos]
  14.                 ([EventoId],
  15.                 [Nome],
  16.                 [Path],
  17.                 [TipoArquivo],
  18.                 [CreationTime],
  19.                 [Ordem])
  20.             VALUES
  21.                 (18,
  22.                 CONCAT('Flairs-Aniversario-Trigemeos-', @v),
  23.                 CONCAT('/Assets/Site/images/eventos/07/flairs-aniversario-trigemeos-', @v, '.jpg'),
  24.                 'foto',
  25.                 '2017-06-29',
  26.                 @i + 2)
  27.  
  28.  
  29. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement