Ten Common SQL Programming Mistakes

Ten Common SQL Programming Mistakes :

The list of common mistakes

• NULLs and the NOT IN predicate
• Functions on indexed columns in predicates
• Incorrect subquery column
• Data type mismatch in predicates
• Predicate evaluation order
• Outer joins and placement of predicates
• Subqueries that return more than one value
• Use of SELECT *
• Scalar user-defined functions
• Overuse of cursors

For brief description please go through the below link

https://www.simple-talk.com/sql/t-sql-programming/ten-common-sql-programming-mistakes/