loop to insert
I'm trying to add into my qr_code table 100 new qr_codes.
I've got this code
But I get an error stating:
I struggle finding what is wrong with my loop. looking online at the syntax it's the same
I've got this code
declare @var int;
set @var = 0;
while @var < 100
begin
insert into qr_codes(store_id, action_type, value, is_redeemed, unique_key)
values (195, 2, 20, false, 78ZREZ87EZ12)
set @var =@var+1;
endBut I get an error stating:
Failed to validate sql query: syntax error at or near "@"I struggle finding what is wrong with my loop. looking online at the syntax it's the same
