T-SQL: Cursor

Performing iterative actions. Update: SQL Server 2008 introduced a new feature to T-SQL, Common Table Expressions (CTEs) which is meant… Read more T-SQL: Cursor

T-SQL: Cross-Database Logic

Executing T-SQL against different databases. Often when accessing and manipulating data, requirements demand logic that crosses databases. Performing such actions… Read more T-SQL: Cross-Database Logic

T-SQL: Control Flow

Implementing decision-making into logic. The ability to control how logic is executed is central to all logic within the data… Read more T-SQL: Control Flow

T-SQL: Compound Operators

Performing shorthand arithmetic While it’s possible to perform simple arithmetic operations by repeating the use of variables, shorthand notation provides… Read more T-SQL: Compound Operators

T-SQL: Complex Queries

Advanced Concepts Apart from some of the latest advancements in t-sql, Ranking Functions for example, the t-sql query language provides… Read more T-SQL: Complex Queries