joins, SQL Simantics

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!

Querying Oracle Nested Tables

Randy Sims Oracle

Nested tables are one method you can use in Oracle to store a one-to-many relationship. You essentially put a table inside of another table. The nested table is actually stored separately and is linked to the original table by the unique row id. Working with this kind of table and the data within is different.

Full Outer Joins

Randy Sims SQL Fundamentals I

When you want to see a list of all values from two tables in a join, even if there are no matches, you want the Full Outer join. It fills in nulls on both sides where needed.

The Capabilities of a SQL SELECT Statement

Randy Sims SQL Fundamentals I

Exam Topic: Retrieving Data Using the SQL SELECT Statement – List the capabilities of SQL SELECT statements By far, the most important skill for anyone to possess when working with a database is the skill to extract from the database the data you want in the format you desire. The SELECT statement, therefore, is the most important […]