Click here to Skip to main content
11,789,710 members (61,226 online)
Rate this: bad
Please Sign up or sign in to vote.
Hello experts! Smile | :)
I want to apply Transaction set in below sql queries
--start tran.
--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 21:03pm
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 999
1 Maciej Los 765
2 KrunalRohit 686
3 CPallini 606
4 Richard MacCutchan 430

Advertise | Privacy | Mobile
Web02 | 2.8.1509028.1 | Last Updated 8 Apr 2013
Copyright © CodeProject, 1999-2015
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