Developer Simon Holywell has written a comprehensive guide for SQL developers. This will allow us to create more readable code, consistent, and easier to be maintained if the current developer moves to another position or leaves the project. The link is https://www.sqlstyle.guide
On their page https://www.sqlstyle.guide/#avoid, it gives some things to avoid:
- camelCase—it is difficult to scan quickly.
- Descriptive prefixes or Hungarian notation such as sp_ or tbl.
- Plurals—use the more natural collective term where possible instead. For example staff instead of employees or people instead of individuals.
To see the overview, visit https://www.sqlstyle.guide/#overview.
To know more about the author, this is his website:
https://www.simonholywell.com/about-me/