How to create script in sql server?

Question

i want to create a script in sql server for using for and if in my query

Answer 1

declare @counter int = 0;

while @counter < 10
begin
if @counter = 5
break;
else
select getdate()
set @counter = @counter+1;
end;

Answer 2

thanks

Answer 3

where are you r8w8