TSQL select values from list which do not exist in table

tsql-select-values-except-exists-in-table

/**
 * Introducing the EXCEPT operator.
 * To select values from a list, use the VALUES operator, and assign that to a table keyword, like so:
 */
SELECT dagnaam FROM (VALUES
  ('maandag'),
  ('dinsdag'),
  ('woensdag')
) E(dagnaam);

/**
 * To select all those in that list, except for those that exist in a table, use the EXCEPT operator:
 */
SELECT dagnaam FROM (VALUES
  ('maandag'),
  ('dinsdag'),
  ('woensdag')
) E(dagnaam) 
EXCEPT 
SELECT name from days where language = 'nl'; 

/**
 * The result is the list of missing values.
 *
 * Happy coding!
 */

TSQL or T-SQL stands for Transact SQL. It is an SQL dialect used by Microsoft in their DBMS, SQL Server Management Studio (SSMS for short).

[https://learn.microsoft.com/en-us/sql/t-sql/language-elements/set-operators-except-and-intersect-transact-sql?view=sql-server-ver16](Microsoft Learn: Except and Intersect)