Rob McNicol

Conversion of a plain English problem into T-SQL

An example of how a mathematical problem was converted into T-SQL by evolving a script in iterations.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

3.85 (20)

You rated this post out of 5. Change rating

2011-10-03

4,959 reads

The Source Control Dilemma Every DBA has been there. Trying to keep track of...

We recently published an article on CHOOSE at SQL Server Central. I thought it...

Introduction Treating your data catalog like a “data museum”—a static collection where information quietly...

Forgot I posted a similar issue back in 2020, String or Binary Truncation Error...

If I have Read replica (in Azure SQL MI), can it be used as...

Hello, I'm tasked with setting up a 2 node server cluster that will host...

What is returned from this code in SQL Server 2022?

DECLARE @value INT = NULL;
SELECT ISNULL(@value, 100.5) AS Result;