The Sql Dev – Page 2 – Sql Development, PowerShell, and more …

How To Split A String in SQL

How To Split A String in SQL Anyone who has worked with SQL long enough comes to a point where they need to split strings into multiple fields. For simple strings how would you do this? Lets take a look at some simple examples. Example 1 Take this example: DECLARE …

Andy Stowell 2022-10-18 2022-11-09 SQL Server

SQL JOINS

Joins in SQL What are joins? JOINS are used to take rows from two or more tables and combine those rows together based on column(s) from each table. There are several types of JOINs in SQL and each type determine which rows are combined. What types of joins exist? When …

Andy Stowell 2022-10-11 2022-11-09 SQL Server