Stored Procedure - atomicity ?
Jan 10, 2013
Is a stored procedure atomic or individual voltExecuteSQL statements within it are ?
In other words, if I have several voltExecuteSQL in my stored procedure; does a failure of even a single of them imply no change was done by the stored procedure or earlier voltExecuteSQL in the stored procedure could have changed the database permanently ?
Thanks.
In other words, if I have several voltExecuteSQL in my stored procedure; does a failure of even a single of them imply no change was done by the stored procedure or earlier voltExecuteSQL in the stored procedure could have changed the database permanently ?
Thanks.