Microsoft Dot Net
Translate
Wednesday, January 18, 2012
how to read uncommitted data in sql server
Example
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Comments will appear once they have been approved by the moderator