Guest User

Untitled

a guest
Jan 12th, 2019
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.24 KB | None | 0 0
  1. Reading the number of rows inserted from another ongoing transaction
  2. BEGIN TRANSACTION
  3.  
  4. INSERT INTO Table2 WITH(TABLOCK)
  5. SELECT BLAH
  6. FROM Table
  7.  
  8. COMMIT TRANSACTION
  9.  
  10. SELECT COUNT(*) FROM Table2
  11.  
  12. SELECT COUNT(*) FROM Table2 WITH (NOLOCK);
Add Comment
Please, Sign In to add comment