What are the challenges you face when working across database platforms? Take the survey
Options

WITH requirement in NOLOCK hint

asentellasentell Posts: 42
edited December 31, 2009 10:54AM in SQL Prompt Previous Versions
I am very pleased with the latest release of SQL Prompt, so thanks for your hard work on this product. It makes my life a lot easier on a day-to-day basis.

The only issue I have is that when using the NOLOCK hint I have to include the WITH keyword (e.g., "WITH (NOLOCK)") in order for SQL Prompt to continue functioning. This isn't a big deal to me, but a majority of our stored procs do not include the WITH keyword so it would be nice if SQL Prompt did not require it.

Thanks,
Aaron

Comments

Sign In or Register to comment.