Dear All,
Table values are getting rollback without calling rollback.
I have a table Test with some columns in it.
Here's the Table Structure:-
Create Table TestID
(
TestID int not null,
MyID int
);
I am calling two procedures one is get the value of MyID column and one is to set the
value after that.
FirstProc :-
Create procedure SP_GetMyID(TestID int)
Begin
Select MyID From Test Where TestID = TestID;
End;
Call SP_GetMyID(1);
[OUTPUT = 1]
If suppose the above proc returns me 1 as MyID then below proc will set MyID as 2
(incrementing by one)
Call SP_SetMyID(1,2);
Create Procedure SP_SetMyID(TestID int, NewMyID int)
Begin
Update Test
Set MyID = NewMyID
Where TestID = TestID;
End;
After setting the value I am again calling get procedure
Call SP_GetMyID(1);
[OUTPUT = 2]
and if after some time say after 10 seconds if I m calling SP_GetMyID again. It gives me
OUTPUT as 1.
--
Regards,
Manasi Save
Artificial Machines Private Limited
manasi.save@stripped
Ph:-9833537392
Attachment: [text/html] HTML Version of Message
Attachment: [text/html] HTML Version of Message
