关于SQL Server的WITH(NOLOCK)和(NOLOCK)

The difference is that you should be using the syntax WITH (NOLOCK) (or WITH (<any table hint>)). Why?

1. Without WITH is deprecated. From Table Hints on MSDN:

2. from table1 nolock does not apply a hint at all - that's an alias. For example:

   SELECT nolock.name FROM sys.objects nolock ORDER BY nolock.name;
   
   

   Notice that I can use nolock as an alias. No hint is applied here.

3. from table1 as mytable nolock is invalid syntax in modern versions of SQL Server.