All Forums Database
marcmc 112 posts Joined 12/05
30 May 2007
Dirty Reads

When wishing to do a dirty read in SQLServer I would do this... Sel * From Tbl_1(nolock), Tbl_2(nolock) Where Col1 = Col2....The equivalent is 'Locking Table For Access' in Teradata but what if I want to use 2 tables like above how does the syntax go? Is there a locking rows for access command?

Barry-1604 176 posts Joined 07/05
30 May 2007

Yes...LOCKING ROW FOR ACCESSSELECT ....It will escalate the lock to a table level lock when appropriate.

Barry-1604 176 posts Joined 07/05
30 May 2007

I should have clarified the last sentence:It will escalate the lock to a table level access lock when appropriate.

You must sign in to leave a comment.