MSSQL - While Loop example

 Watch this example on YouTube

Declare @i int = 0;
While @i < 10
Begin
    Insert into Test1(Name) values('frank ' + Cast(@i as varchar))
    Set @i = @i + 1;
End