Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
abc123
Starting Member
47 Posts |
 Posted - 2009-02-20 : 03:56:51
|
| Hi, is it possible to use NOLOCK in update query?And if i use NOLOCK in update then what will happen? |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-02-20 : 04:06:32
|
| This is the default for SELECT operations. It does not apply to INSERT, UPDATE, and DELETE statements.for details see books online |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-20 : 06:47:48
|
quote:
Originally posted by bklr
This is the default for SELECT operations. It does not apply to INSERT, UPDATE, and DELETE statements.for details see books online
This is not default for SQL Server. Read Committed is default for SQL Server.Update query puts exclusive locks. |
|
|
|
Rajesh Jonnalagadda
Starting Member
45 Posts |
Posted - 2009-02-20 : 07:47:45
|
| This is the statement given by microsoft in this link http://msdn.microsoft.com/en-us/library/ms187373.aspxNOLOCK Is equivalent to READUNCOMMITTED. Note: For UPDATE or DELETE statements: This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Rajesh Jonnalagadda[url="http://www.ggktech.com"]GGK TECH[/url] |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-20 : 07:49:53
|
| Doesn't make sense to use NOLOCK in DML queries. |
|
|
|
abc123
Starting Member
47 Posts |
Posted - 2009-03-05 : 04:07:02
|
| is it possible to use NOLOCK on DELETED and INSERTED magic tables? |
|
|
|
shaggy
Posting Yak Master
248 Posts |
Posted - 2009-03-05 : 08:22:24
|
| it will not use nolock if we define also |
|
|
|
|
|
|
NOLOCK