I wanted to like this post.
My biggest critique is your use of quoted identifiers. Seriously, no one should do that.
Here is an interesting exchange on the topic: stackoverflow.com/questions/646833...
Summarizing:
The SQL 92 standard does not mandate double-quoted identifiers, it permits them. Just because you can, doesn't mean you should. So stick to upper case and underscore.
Using double quoted identifiers to refer to database tables, views, and columns is much more confusing and risky. Having a table named "Person" allows someone else to create a view named PERSON.
I first learned SQL on MS SQL Server. That product allows for ignoring case when quoted identifiers are set off. So you'll see identifiers named like LastName rather than LAST_NAME. I used to think this was a problem. I was wrong.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
I wanted to like this post.
My biggest critique is your use of quoted identifiers. Seriously, no one should do that.
Here is an interesting exchange on the topic:
stackoverflow.com/questions/646833...
Summarizing: