daily pastebin goal
76%
SHARE
TWEET

Untitled

a guest Jan 12th, 2019 56 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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);
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top