Tag: SQL

http://stackoverflow.com/questions/406294/left-join-and-left-outer-join-in-sql-server As per the documentation: FROM (Transact-SQL): <join_type> ::= } } ] JOIN The keyword OUTER is marked as optional (enclosed in square brackets), and what this means in this…

http://stackoverflow.com/questions/49925/what-is-the-difference-between-union-and-union-all UNION removes duplicate records (where all columns in the results are the same), UNION ALL does not. There is a performance hit when using UNION vs UNION ALL, since…