Take the 2-minute tour ×  I wrote a stored procedure to insert a
record. I added "Begin Transaction" just above the Insert Query
and execute the query. I noticed that another application that
was showing a web page with records from the same table, hanged
by the time the insert completed.  Why Begin Transaction locks
the entire table? Writers should not block Readers. It should be
ON by default.  I am using SQL-Server 2005 Express. I also want
to know how Oracle and MySQL handles the same situation.
share|improve this question This may be a stupid question, but
do you actually commit the transaction at the end? –  Mike C Sep
30 '11 at 19:03 @MikeC: I was wondering the same thing myself.
–  MyItchyChin Sep 30 '11 at 19:20 @MikeC Yes, I do. –  RPK Oct
1 '11 at 4:11 add comment  4 Answers  Begin Transaction is the
start of a transaction - no other data can be written to the
table until you end your transaction, this is by design, so as
to enforce the ACID criteria on the database.
http://en.wikipedia.org/wiki/A