۱۳۹۶ اردیبهشت ۲۹, ۰۱:۲۷ ب.ظ
10 اشتباه رایج در استفاده از SQL Server:
https://www.simple-talk.com/sql/t-sql-pr...-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
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
https://www.simple-talk.com/sql/t-sql-pr...-mistakes/