Using Coalesce to Clean Up Reports

One of the lesser used functions is COALESCE(), used to allow you to return one value from a list of those that are potentially NULL. This short pieces gives a few examples where this is useful?

Zero or Hero?

Default OPENJSON

GoTo Looping

While not recommended, GOTO can be used to loop in some situations.

Migrate Key-Value Pairs from Python Dictionary to SQL Server via JSON

This article will demonstrate how to migrate via JSON, key-value pairs from a Python dictionary object to a SQL Server table.

What does SET NOCOUNT ON do?

When you’re working with T-SQL, you’ll often see SET NOCOUNT ON at the beginning of stored procedures and triggers. What SET NCOUNT ON does is prevent the “1 row affected” messages from being returned for every operation. Read Brent's blog to see him demo it by writing a stored procedure in the Stack Overflow database.

The CURRENT_TIMESTAMP

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.