OK... so I'm learning transactions. I have a question.
I see lots of transactions like this:
BEGIN TRANSACTION;
INSERT INTO myTable (id, value) VALUES (1, 1);
ROLLBACK TRANSACTIon;
COMMIT;
Does this mean taht it will only rollback if ther's an error, or else it'll commit, or does it meanb it'll rollback all the time?
--Jason
I see lots of transactions like this:
BEGIN TRANSACTION;
INSERT INTO myTable (id, value) VALUES (1, 1);
ROLLBACK TRANSACTIon;
COMMIT;
Does this mean taht it will only rollback if ther's an error, or else it'll commit, or does it meanb it'll rollback all the time?
--Jason