What are the most common SQL anti-patterns? [closed]

I am consistently disappointed by most programmers’ tendency to mix their UI-logic in the data access layer: SELECT FirstName + ‘ ‘ + LastName as “Full Name”, case UserRole when 2 then “Admin” when 1 then “Moderator” else “User” end as “User’s Role”, case SignedIn when 0 then “Logged in” else “Logged out” end as … Read more

What is an anti-pattern?

Anti-patterns are certain patterns in software development that are considered bad programming practices. As opposed to design patterns which are common approaches to common problems which have been formalized and are generally considered a good development practice, anti-patterns are the opposite and are undesirable. For example, in object-oriented programming, the idea is to separate the … Read more