April 11, 2012 at 12:14 pm
Hi
I have a task.
in that i need to run same stored procedure multiple time.
uspProgram_updatestudentprogram '004426495',-1,555,136,'2011-09-01 00:00:00.000',null,null,null,'','','',0
uspProgram_updatestudentprogram '004308638',-1,559,136,'2011-09-01 00:00:00.000',null,null,null,'','','',0
uspProgram_updatestudentprogram '004456262',-1,559,136,'2011-09-01 00:00:00.000',null,null,null,'','','',0
i am try to run in once but i got error.
so please help me to run this proc in one transaction.
is it possible?
April 11, 2012 at 12:17 pm
surma.sql (4/11/2012)
HiI have a task.
in that i need to run same stored procedure multiple time.
uspProgram_updatestudentprogram '004426495',-1,555,136,'2011-09-01 00:00:00.000',null,null,null,'','','',0
uspProgram_updatestudentprogram '004308638',-1,559,136,'2011-09-01 00:00:00.000',null,null,null,'','','',0
uspProgram_updatestudentprogram '004456262',-1,559,136,'2011-09-01 00:00:00.000',null,null,null,'','','',0
i am try to run in once but i got error.
so please help me to run this proc in one transaction.
is it possible?
This:
exec uspProgram_updatestudentprogram '004426495',-1,555,136,'2011-09-01 00:00:00.000',null,null,null,'','','',0
exec uspProgram_updatestudentprogram '004308638',-1,559,136,'2011-09-01 00:00:00.000',null,null,null,'','','',0
exec uspProgram_updatestudentprogram '004456262',-1,559,136,'2011-09-01 00:00:00.000',null,null,null,'','','',0
April 11, 2012 at 12:43 pm
Thanks
Appreciate for Your Quick Response
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply