The Elusive Conditional WHERE Clause
What's this, a conditional WHERE clause that doesn't use dynamic SQL?
2017-01-27 (first published: 2013-04-18)
39,537 reads
What's this, a conditional WHERE clause that doesn't use dynamic SQL?
2017-01-27 (first published: 2013-04-18)
39,537 reads
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
By Steve Jones
One of the features we advocates have been advocating for is a better way...
I am creating shared datasets that our executive staff can use for creating reports...
I am creating shared datasets that our executive staff can use for creating reports...
Comments posted to this topic are about the item Delta Lake: The Definitive Guide:...
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers