Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Reading the number of rows inserted from another ongoing transaction
- BEGIN TRANSACTION
- INSERT INTO Table2 WITH(TABLOCK)
- SELECT BLAH
- FROM Table
- COMMIT TRANSACTION
- SELECT COUNT(*) FROM Table2
- SELECT COUNT(*) FROM Table2 WITH (NOLOCK);
Add Comment
Please, Sign In to add comment