Transaction lock in sql

by

I am assuming you are using SQL Server. You can use the WITH NOLOCK hint in your select statement, so the read goes through. However, you should be aware that it is a dirty read. Since the update statement is changing the data and the changes may or may not have been committed, the result of the read (select) statement can be problematic.

Here is a link to a page with more details and simple examples
https://www.mssqltips.com/sqlservertip/2470/understanding-the-sql-server-nolock-hint/

More Related Contents:

  1. SQL function PIVOT with 2 column
  2. SQL query for display one field only once which having multiple record
  3. SQL/mysql – Select distinct/UNIQUE but return all columns?
  4. Convert UTF-8 String Classic ASP to SQL Database
  5. Difference between LIKE and ~ in Postgres
  6. Multiple INNER JOIN SQL ACCESS
  7. Pivot on Multiple Columns using Tablefunc
  8. Dynamically create columns sql
  9. Multiple CTE in single query
  10. Return pre-UPDATE column values using SQL only
  11. Selecting data into a Postgres array
  12. SQL syntax term for ‘WHERE (col1, col2) < (val1, val2)'
  13. How to run a stored procedure in sql server every hour?
  14. How do I see active SQL Server connections?
  15. UPDATE if exists else INSERT in SQL Server 2008 [duplicate]
  16. Questions every good Database/SQL developer should be able to answer [closed]
  17. How to run a stored procedure every day in SQL Server Express Edition?
  18. Calculate the number of records for each date between 2 dates
  19. What is causing Foreign Key Mismatch error?
  20. T-SQL: How to use parameters in dynamic SQL?
  21. MySQL – how to front pad zip code with “0”?
  22. How to compare datetime with only date in SQL Server
  23. How can I implement SQL INTERSECT and MINUS operations in MS Access
  24. Split words with a capital letter in sql
  25. Access 2010: Syntax error (missing operator) in query expression
  26. Generate random int value from 3 to 6
  27. scope_identity vs ident_current
  28. SQL join on multiple columns in same tables
  29. SQL query to group by day
  30. ORA-00942: table or view does not exist (works when a separate sql, but does not work inside a oracle function)

Leave a Comment