You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Question on MSSQL select statement?
- Thread starter KokKeong
- Start date
Mr-Blanke2007
New Member
No the table can be updated and modified by another query while your select statement is running.
DayTripper
New Member
Right. You'd have to "manually" lock/unlock the table. But you usually only want to do that when you make an UPDATE to the table, not a SELECT.
Shaka_DaMan
New Member
Well it depends on the locking scheme that you are using with the database. On any case the whole table will not lock, however there is always the potentional for that data page you are selecting could be locked and have to wait until your select was finished for a transaction to grab that same data page.
As a good practice it's always a practice to use the WITH (NOLOCK) hint
Example
SELECT * FROM TableName WITH (NOLOCK)
You can also specify the (NOLOCK) hint directly after the TableName
As a good practice it's always a practice to use the WITH (NOLOCK) hint
Example
SELECT * FROM TableName WITH (NOLOCK)
You can also specify the (NOLOCK) hint directly after the TableName