In some MSSQL views I have WITH (NOLOCK) statements after the table names.
E.g. the SELECTs look something like this:
SELECT *
FROM mytable WITH (NOLOCK)
Such WITH statements should be removed when generating the PostgreSQL schemas for views, triggers, and stored procedures.
Sebastian
In some MSSQL views I have
WITH (NOLOCK)statements after the table names.E.g. the SELECTs look something like this:
Such
WITHstatements should be removed when generating the PostgreSQL schemas for views, triggers, and stored procedures.Sebastian