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 BillWoodruff 260
1 Mathew Soji 244
2 Afzaal Ahmad Zeeshan 232
3 OriginalGriff 231
4 Maciej Los 230
0 OriginalGriff 6,369
1 Sergey Alexandrovich Kryukov 5,973
2 DamithSL 5,183
3 Manas Bhardwaj 4,673
4 Maciej Los 4,045


Advertise | Privacy | Mobile
Web01 | 2.8.1411019.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