Here’s a just-so-crazy-it-might-work way of doing a for loop in sql server.

This comes in real handy when making fake data for testing purposes.

  
DECLARE @count INT  
DECLARE @command_to_loop NVARCHAR(1000)  
-- This example runs from 1 to 10
SET @count = 1  
WHILE(@count <= 10)  
BEGIN  
-- This is just my crazy example
-- Replace @command_to_loop with whatever you want to execute loop
SET @command_to_loop = 'insert into customers (name) values  
(''Billy Bob' + cast(@count as varchar(3)) + ''')'
print @command_to_loop  
EXEC sp_executesql @command_to_loop  
SET @count = @count + 1  
END  
Need to find a lawyer for your business? Get in touch with my company Lexoo and we'll find you a great one for free.