Does stored procedure with select statement called from another stored procedure with transaction lock the table?

112 Views Asked by At

I have a stored procedure calling another stored procedure. The outer stored procedure got tran while the inner stored procedure has no tran just select statement. Does the table in the inner tran gets locked?

The stored procedure s looks like this:

OUTER_SP

BEGIN TRANSACTION
    BEGIN
        EXEC INNER_SP

        INSERT INTO TABLE A
    END
    COMMIT TRANSACTION

INNER_SP

SELECT FROM TABLE A
0

There are 0 best solutions below