use string_split to actually join your multiple choices to a table! #SQLServer2016 #SQL #TSQL
Tag: joins
SQL Server: Duplicate Rows with Your Own Values Using STRING_SPLIT and CROSS JOIN
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
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. … Continue reading Querying Oracle Nested Tables
Full Outer Joins
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. Try this query: SELECT * FROM hr.regions FULL OUTER JOIN hr.countries USING (region_id); If you look through the … Continue reading Full Outer Joins
The Capabilities of a SQL SELECT Statement
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 … Continue reading The Capabilities of a SQL SELECT Statement
DataSimAntics 