Selecting data without making any lock

Question

Hi Expert,

  I have a scenarios where if I execute select * from tbl it should display the all the records without waiting to release any lock.  For example suppose I have one table called tbl and one session is updating one records and not committed yet and in other session if i execute select * from table I can see all the records, for that records it can show me older version. but my select statement should not wait to commit another session and also it should not show the modified data.

 

---

Regards Vikas Pathak

Answer 1

https://msdn.microsoft.com/en-gb/library/ms173763.aspx?f=255&MSPPError=-2147217396

https://technet.microsoft.com/en-us/library/ms188277%28v=sql.105%29.aspx?f=255&MSPPError=-2147217396

---

Thanks, Andrew
My blog...

Answer 2

Hi Vikas,

You can use Nolock as the query below

SELECT 
    *
FROM dbo.person  WITH (NOLOCK)

Thanks,

Amit

Answer 3

Thank you amit for reply but I mentioned above " but my select statement should not wait to commit another session and also it should not show the modified data."

 In case of nolock it will show mw modified and uncommitted records.

---

Regards Vikas Pathak

Answer 4

Thank you  Andrew

---

Regards Vikas Pathak