October 9, 2005 at 11:47 pm
I have two question ..
1) What's is transaction management ?? how we can achive it in t-sql block or in stored proc ?
2) I have three stored porc
Proc_A , Proc_B, Proc_C
if Proc_A is calling Proc_B , Proc_B calling Proc_C , Proc_C calling Proc_A , what will happne ??
3) is question 2 have any relation with question 1 ??
Thanks
October 10, 2005 at 9:26 am
1) probably easiest if you look up something like 'Begin Transaction' in BOL to get a general understanding but simply, a transaction is a single unit of work that either completes successfully, commiting changes, or doesn't commit successfully and therefore changes are rolled back.
3) Standard DBA response - Depends!! If you control the flow within a Tranascation then 2) does depend on 1)
As i said, if you have a read of BOL and then post any other questions in this forum to clear up any other points.
Growing old is mandatory, growing up is optional
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply