2
Vote

No detection of mandatory "WITH" when specifying table hints

description

In SQL azure
SELECT * FROM t0 (NOLOCK)
is illegal and should be rewritten explicitating "WITH",
SELECT * FROM t0 WITH (nolock).
Apparently other hints must also be specified using "WITH".
 
This is not supported in the pre analysis in the wizard.

comments

ghuey wrote Oct 13, 2010 at 10:19 PM

Agreed. I will make a change to the NotSupportedByAzureFile.config in v3.4.1.

Thanks,
George