sql server tsql for döngüsü örn :

declare @id int

declare cridler cursor 

 for SELECT  id FROM [kurul].[dbo].[personel_bilgileri]  where id not in(select perid from personel_gorev_unvanlari_rlt)  

open cridler 

fetch next from cridler into @id  

while @@FETCH_STATUS=0  

begin 

 insert into personel_gorev_unvanlari_rlt(perid,gorevunvanid) values(@id,9)

 fetch next from cridler into @id  

end 

close cridler  

deallocate cridler