T-SQL EXCEPT and INTERSECT
Both T-SQL EXCEPT and INTERSECT are set based operators that combine multiple query results back in the same...
2015-03-03 (first published: 2015-02-23)
Set operators allow you to combine data from two or more queries and return the results in a single...
2015-02-13 (first published: 2015-02-04)
SQL Server T-SQL coalesce simplifies the use of a case statement to find the first non-null value of your...
2014-12-30 (first published: 2014-12-26)
Row_Number SQL Server
SQL Server includes several Ranking Functions that can be called in T-SQL. One of these is the Row_Number()...
2014-12-22 (first published: 2014-12-16)