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 OriginalGriff 200
1 George Jonsson 175
2 Kornfeld Eliyahu Peter 169
3 PIEBALDconsult 110
4 Richard MacCutchan 85
0 OriginalGriff 6,080
1 DamithSL 4,648
2 Maciej Los 4,087
3 Kornfeld Eliyahu Peter 3,624
4 Sergey Alexandrovich Kryukov 3,294


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