COALESCE Vs ISNULL

To switch or not to switch

More of computed columns

Return to Sender: Identity Values and Triggers

By quickly and easily obtaining the identity value, the OUTPUT clause of an INSERT statement can obtain the auto-generated identity value of a row, and so will allow the application to immediately reference the new row or add rows to another table that use the identity value as a foreign key reference.

Computed column

Predict the total count

Using OVER with an Aggregate Function

Hierarchical Data Structure Virtualization in SQL

Data structure virtualization is the constructing of a data structure utilizing pieces or fragments from other data structures. This article demonstrates how Data structure virtualization can be performed in ANSI SQL utilizing hierarchical processing techniques to produce hierarchically structured virtualized output.

Predict the outcome of the SQL statements

What will the results be for the code below?