Opening JSON Data with T-SQL

The T-SQL code samples in this tip illustrate ways of displaying JSON formatted data in SQL Server as well as how to transfer JSON formatted data to SQL Server tables.

Checking the Date

SQL Server T-SQL CASE Statement Examples

This tip will teach you when and how you can use CASE in T-SQL statements with several code examples to give you a better understanding.

The Number Subquery

The Full OFFSET

Never, Ever, Ever Start T-SQL Comments with Two Dashes

In this article, Brent Ozar explains why you should avoid starting T-SQL comments with two dashes.

Navigating Trees With CTE

Introduction This article shows how common table expressions (CTE) in SQL Server are naturally suited for navigating trees, such as finding its longest path, or diameter. Recall that a tree is an undirected graph where unique paths exist between any two nodes (i.e. vertices). Any node may be selected as its top node, with its […]

Numbers to Letters

Output Parameters

Preventing Trigger Execution