September 2018, SQL Simantics

SQL Server Set Operators: UNION, INTERSECT, and EXCEPT

Randy Sims SQL Server

Did you know you can do set-based math with SQL Server? With the UNION, INTERSECT, and EXCEPT set operators, you can compare one result set to another and add or subtract results, called a compound query. This can be a handy tool for your toolbox. This is very similar to Oracle Set Operators: UNION, INTERSECT and MINUS

SQL Server: Fake a Dynamic IN with STRING_SPLIT

Randy Sims SQL Server

use string_split to actually join your multiple choices to a table! #SQLServer2016 #SQL #TSQL

SQL Server: Duplicate Rows with Your Own Values Using STRING_SPLIT and CROSS JOIN

Randy Sims SQL Server

SQL Server 2016 came out with the STRING_SPLIT function that will return what amounts to a table from character-separated string. Using a CROSS JOIN with this function, you can return one row multiple times with whatever values you want!

Review: SQL Operations Studio (Preview) for SQL Server

Randy Sims SQL Server

As someone who develops on SQL Server every day, I wanted to try it out the latest gizmo, SQL Operations Studio, or SQLOps. I hoped it was going to be my new favorite toy with all those extensions. In the end, I’m fine with it. There is one problem and a couple of missing features, […]