Difference with (nolock) vs (nolock) as a SQL Table Hint:
select sum(amount) from reward_expired (nolock)
difference was between using the table hint (nolock) and the table hint with (nolock).
Look at MSDN under SQL 2005,
“In SQL Server 2005, with some exceptions, table hints are supported in the FROM clause only when the hints are specified with the WITH [...]
Filed under: with (nolock) vs (nolock) | Tagged: Difference with (nolock) vs (nolock), FASTFIRSTROW, Microsoft SQL server, MSSQL, MSSQL server, NOEXPAND, NOLOCK, NOWAIT, PAGLOCK, READCOMMITTED, READPAST, READUNCOMMITTED, REPEATABLEREAD, ROWLOCK, SERIALIZABLE, SQL help, SQL Server, SQL Tips, SQL Tricks, T-SQL best way, Table Hints, TABLOCK, TABLOCKX, UPDLOCK, with (nolock) vs (nolock), XLOCK | Leave a Comment »
