I am quite a beginner in SQL server. Few days back I came across a question, I am wondering what can be the answer for that. Pls help me out if anyone knows the answer. The question goes as below :
There is a stored procedure (say proc1) which has transaction block implemented. Now I call another stored procedure(say proc2) within the proc1. Proc2 contains a simple insert into table statement. Now some error occurs :
1) Tell me whether the inserted data (from proc2) will be rollbacked or not?
2)How can u manage not to rollback the inserted rows (from proc2) however other data must be rollbacked (proc1).
Thanks in advance.
View Complete Post