Build date table

Eval arithmetic statement function in SQL

This function evaluates the statement like '4+5*6-3' and returns the numeric value.It is just like Eval funcction in javascript.

Nulls

Group Islands of Contiguous Dates (SQL Spackle)

Fill in another bit of your T-SQL knowledge by learning how to quickly group ranges of contiguous dates without RBAR.

LIKE and = Operators

Returning the Top X row for each group (SQL Spackle)

One of the most common T-SQL questions is on returning a ranked result set for each member of a group. Dave Ballentyne brings us a short tutorial on how you can do this in T-SQL.

sys.syscomments

Extending SQL's Inherent Hierarchical Processing Operation

This article covers multipath operations that require a different hierarchical logic than SQL naturally produced hierarchical processing. These include nonlinear data ordering, the renormalization of data to remove replicated data, and the processing of network structures.

Transactions

T-SQL GO statement