I may be misusing the term "transactionality", so here's the simple explanation:
I want to write a stored procedure that does this:
INSERT INTO TABLE_A VALUES "A"
INSERT INTO TABLE_B VALUES "B"
And if either fails to insert, BOTH should fail to insert.
First, Is the use of a stored procedure a valid way to accomplish this?
And second, will it still work if the database's recovery mode is set to simple? If not, will anything work if recovery mode is set to simple?