Skip to content

Instantly share code, notes, and snippets.

@ArCiGo

ArCiGo/1. Example. IF...THEN...ELSE.sql

Created May 19, 2019 23:49
Show Gist options
  • Save ArCiGo/54095cd12e802b28d83f95d5675222bd to your computer and use it in GitHub Desktop.
Save ArCiGo/54095cd12e802b28d83f95d5675222bd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
1. Example. IF...THEN...ELSE.sql
IF DATENAME(weekday, GETDATE()) IN ('Saturday', 'Sunday')
SELECT 'Weekend'
ELSE
SELECT 'Weekday'
/** Output **/
-------
Weekend
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment