nolock? What is the difference between the REPEATABLE READ and SERIALIZE isolation levels?
Locking Hints – A range of table-level locking hints can be specified using the SELECT, INSERT, UPDATE, and DELETE statements to direct Microsoft® SQL Server 2000 to the type of locks to be used. Table-level locking hints can be used when a finer control of the types of locks acquired on an object is required. These locking hints override the current transaction isolation level for the session.
| Print article | This entry was posted by on December 13, 2009 at 9:51 am, and is filed under Faqs, SQL. Follow any responses to this post through RSS 2.0. You can leave a response or trackback from your own site. |
about 1 year ago
Genial post and this enter helped me alot in my college assignement. Say thank you you as your information.