Last Updated: February 25, 2016
·
583
· nlingutla

SQL Query writing style

Whenever you are writing some SQL statements in your code, it would be nice to

-> capitalize the non-identifiers to differentiate them from identifiers (table, column and index names)

For example

UPDATE person SET age=50 WHERE name='xyz';

SELECT name, age FROM person;