René's URL Explorer Experiment

Title: WITH statements are not removed · Issue #182 · dalibo/sqlserver2pgsql · GitHub

Open Graph Title: WITH statements are not removed · Issue #182 · dalibo/sqlserver2pgsql

X Title: WITH statements are not removed · Issue #182 · dalibo/sqlserver2pgsql

Description: 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 v...

Open Graph Description: 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...

X Description: 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...

Opengraph URL: https://github.com/dalibo/sqlserver2pgsql/issues/182

X: @github

direct link

Domain: patch-diff.githubusercontent.com

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"WITH statements are not removed","articleBody":"In some MSSQL views I have `WITH (NOLOCK)` statements after the table names.\r\n\r\nE.g. the SELECTs look something like this:\r\n\r\n```sql\r\nSELECT *\r\nFROM mytable WITH (NOLOCK)\r\n```\r\n\r\nSuch `WITH` statements should be removed when generating the PostgreSQL schemas for views, triggers, and stored procedures.\r\n\r\nSebastian","author":{"url":"https://github.com/SebastianZ","@type":"Person","name":"SebastianZ"},"datePublished":"2024-03-05T06:28:09.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/182/sqlserver2pgsql/issues/182"}

Links:

Viewport: width=device-width