All Apps and Add-ons

Is it possible to use NOLOCK in DB Connect Queries?

New Member

Hello All,

My DBA is requesting that I use NOLOCK in all of my DB Connect queries, but I can't seem to figure out how to do so. Is it possible, and what would the syntax be if so?

Please find an example of the query I am using below.

Thanks,
Annmarie

SELECT DateCreated, DateSent, DateResponseCollected, ResponseCode FROM "Commissions"."disbursements"."HyperWalletFiles"
0 Karma

Path Finder

Hi,

Not sure if this would work but you could try:

 SELECT DateCreated, DateSent, DateResponseCollected, ResponseCode FROM "Commissions"."disbursements"."HyperWalletFiles" WITH (NOLOCK)

Hope it helps!

Regards,
Ben

0 Karma