Hello experts! :)
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 :)