Design Patterns: Adapter

Exposing class behavior from another class. Sometimes you might need to access and use functionality defined from one class from… Read more Design Patterns: Adapter

T-SQL: Row_Number

Ranking Functions There are several new impressive advancements in the latest version of t-sql; this article will focus on “Ranking”… Read more T-SQL: Row_Number

T-SQL: Binary_Checksum()

Performing case-sensitive String Comparison While using other string functions or operators may be used to compare strings, the most effective… Read more T-SQL: Binary_Checksum()

T-SQL: Pivot

Dynamically restructuring report data. Often when creating reports, data is received in varying formats, some of which make it difficult… Read more T-SQL: Pivot

T-SQL: Parsing Values

Updating a field with only a portion of its original value. String functions provide powerful methods for manipulating values in… Read more T-SQL: Parsing Values