Convert String to a Table using CTE
Explains how to convert a list of Ids passed as string and convert it to a table
2009-12-14
14,058 reads
Amit Gaur
Blogs
Using OneLake for Excel Files in Microsoft Fabric
By DataOnWheels
Hey data friends! This blog is to discuss an edge case I’ve run into...
Another AI Faux Pax
By Steve Jones
I was experimenting with a local model (article) and as a part of this,...
Monday Monitor Tips: Using the PowerShell API
By Steve Jones
Redgate Monitor has grown tremendously from its early days and I find many customers...
Forums
SSMS gets very messy
At work we have quite a few databases that I'm frequently browsing. This is...
restore db as db_copy. resolve hardcoded references within procedures to db.
So I backup & restore db as db_copy. within both there is a proc...
Transpose sql table rows into columns
I want to transpose sql table rows to columns. I have written a query...
Question of the Day
Sparse Column Defaults
What are the restrictions for defaults on columns declared as sparse?
See possible answers