Gregory Larsen

Currently a SQL Server DBA. I've been working with SQL Server since 1999. I'm an old-time mainframe DBA. My DBA career started in 1985. Currently studying to obtaining MCDBA.

Stairway to T-SQL DML

Stairway to T-SQL DML Level 5: The Mathematics of SQL: Part 2

Joining tables is a crucial concept to understanding data relationships in a relational database. When you are working with your SQL Server data, you will often need to join tables to produce the results your application requires. Having a good understanding of set theory, and the mathematical operators available and how they are used to join tables will make it easier for you to retrieve the data you need from SQL Server.

5 (1)

2019-05-29 (first published: )

17,308 reads

Stairway to T-SQL DML

Stairway to T-SQL DML Level 4: The Mathematics of SQL: Part 1

A relational database contains tables that relate to each other by key values. When querying data from these related tables you may choose to select data from a single table or many tables. If you select data from many tables, you normally join those tables together using specified join criteria. The concepts of selecting data from tables and joining tables together is all about managing and manipulating sets of data. In Level 4 of this Stairway we will explore the concepts of set theory and mathematical operators to join, merge, and return data from multiple SQL Server tables.

5 (6)

2019-05-22 (first published: )

23,354 reads

Blogs

Daily Coping 18 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

New parameter in sp_DBPermissions and sp_SrvPermissions: @CopyTo

By

I’ve added a new parameter to my permissions scripts (well, just the main two...

Creating TAIL on Windows for Text Files

By

UPDATE: Article changed based on the comment from Mr. Sewell. I wrote recently about...

Read the latest Blogs

Forums

How to use PowerShell to set secure SA passwords for bulk servers

By Vincent92

Comments posted to this topic are about the item How to use PowerShell to...

INSERT EXEC statement cannot be nested, the Simple Solution

By Daniel Brink

Comments posted to this topic are about the item INSERT EXEC statement cannot be...

Cleaning Tables

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Cleaning Tables

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers