Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
Hello experts! Smile | :)
I want to apply Transaction set in below sql queries
--start tran.
    query1...
    query2...
    query3...
--end tran.
now, I want that if this query set is in process(being executed) by some one, then others should be wait in queue till one complete task
 
so, which transaction level/lock should I apply on above query sets
Thanks & regards Smile | :)
Posted 7-Apr-13 22:03pm
Comments
skydger at 8-Apr-13 8:35am
   
It depends on what kind of queries do you use.
If these queries are a number of 'insert' statements, you could use 'with tablock' hint. But if you have miscellaneous queries, then you could use
'set transaction isolation level read commited', with 'READ_COMMITTED_SNAPSHOT' option set to off.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Marcin Kozub 265
1 Richard MacCutchan 239
2 OriginalGriff 208
3 Sergey Alexandrovich Kryukov 185
4 Praneet Nadkar 167
0 OriginalGriff 7,913
1 Sergey Alexandrovich Kryukov 7,232
2 DamithSL 5,604
3 Manas Bhardwaj 4,986
4 Maciej Los 4,865


Advertise | Privacy | Mobile
Web03 | 2.8.1411023.1 | Last Updated 8 Apr 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100