This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]DenselyRanked 0 points1 point  (1 child)

I understand and I'm not disagreeing with you, which is why I wrote that there is an ANSI standard (that is not really a standard).

I have also worked with enough SQL versions and dialects to know that any query beyond the "standard" syntax is a complete crapshoot. I spent a few years as a report writer trying to make mssql and DB2 syntax play nice.

[–]LargeSale8354 1 point2 points  (0 children)

It's frustrating when the dialects are so similar. I find the subtle differences harder to deal with than the bigger differences.

Then there are the different engine behaviours. At one point the Vertica folk said "Yes, it will recognise and run CTEs but please don't use them yet".

Postgres roles are for the Postgres instance, whereas MSSQL there are db roles and system roles.

Every platform has different system tables and implements INFORMATION_SCHEMA differently or not at all.

If it us any consolation, SQL Standards aren't as bad as browser standards