I'm using begintransaction to update multi-tables. I need to update one of the table while retrieving some records from that same table before commit. But it seem the table become locked after I inserted a record, and timeout at last.
I've looked begintransaction option and try all IsolationLevel with no luck. Is it possible to do that ? Thanks in advance.