Wednesday, January 18, 2012

how to read uncommitted data in sql server


set transaction isolation level read uncommitted

select * from tblStudents(nolock)

(The text highlighted in yellow prompts SQL server to return uncommitted records)

No comments:

Post a Comment

Comments will appear once they have been approved by the moderator