2014-01-13
1,770 reads
T-SQL
2014-01-09
2,342 reads
A Simple Recursion Finds Joins
When you need to find all the related rows and tables to a parent table, here's one way you might approach the problem.
2014-01-06
8,196 reads
2014-01-03
2,082 reads
2013-12-31
2,307 reads
2013-12-20
2,353 reads
2013-12-16
1,859 reads
The Zero to N Parameter Problem (Sql Server 2005 and Up -- Update)
This article uses XML to deal with optional parameters along with multiple parameter passed into a stored procedure. (Note: We are re-running this as we had a newsletter issue last week)
2013-12-28 (first published: 2013-12-10)
7,532 reads
2013-12-09
2,368 reads
A few reflections on RBAR by a weary application developer
Follow the guidance of your DBA, but remember, he or she is from another land.
2013-12-09
6,909 reads
Blogs
The end of an era – why I chose not to renew my MVP
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
PowerShell Strikes Back: A New Script
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
Claude Desktop
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
Forums
Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform
Comments posted to this topic are about the item Unraveling the Mysteries of the...
QUOTENAME Behavior
Comments posted to this topic are about the item QUOTENAME Behavior
Running script without having permission to Function
Good Morning. I have a T-SQL Script which has been developed to execute a...
Question of the Day
QUOTENAME Behavior
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers