T-SQL: Synonym

Simplifying T-SQL syntax. Length T-SQL is unfortunately the byproduct of many business requirements in supporting an application. As the parts… Read more T-SQL: Synonym

T-SQL: String Search

Returning selection portions of values in a resultset. When searching for specific values within a field, returning portions surrounding the… Read more T-SQL: String Search

T-SQL: Stored Procedure Default Values

Building flexibility into data INSERT operations. Often when designing an application that receives user input, it’s difficult to determine beforehand… Read more T-SQL: Stored Procedure Default Values

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