T-SQL: Checksum

Constructing a hashtable with recordsets. Often times when building complex queries, it becomes difficult linking different sets of data using… Read more T-SQL: Checksum

T-SQL: Bitwise Arithmetic

Using bits as flags. Recording user settings, often as “categories” represents significant persistence within many applications. Storing all these values… Read more T-SQL: Bitwise Arithmetic

T-SQL: WITH

Performing Recursive Queries. Prior to SQL Server 2005, performing recursive actions on data required the use of temporary tables, cursive,… Read more T-SQL: WITH

T-SQL: User Defined Functions

Creating reusable logic. As with Object-Oriented Programming (OOP) where it’s important to separate code used frequently into reusable modules, in… Read more T-SQL: User Defined Functions

T-SQL: Trigger – INSERT AFTER

Initiating actions in response to events. One of the new features provided with SQL Server 2005 enables actions to be… Read more T-SQL: Trigger – INSERT AFTER