Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I created a stored procedure that selects data from one table and inserts loop rows to another table
CREATE PROCEDURE [dbo].[forMark]
@marks int output
,@studentid INT output
,@n int =0
as
SELECT @studentid = studentid, @marks = [ marks]
FROM dbo.tempPersons
WHERE statuscode=0
while @n <@marks
begin
insert into dbo.tempMarks (studentid) values(@studentid)
set @n =@n+1
end
My talend
Is Autocommit option activated on tDBConnecction?
Is Autocommit option activated on tDBConnecction?