IF SQL on WHERE clause
IF SQL on WHERE clause
HTML
if there is no data in role it will not use it
Declare @role varchar(100)
set @role = NULL
AND CASE WHEN @role IS NULL THEN '1' ELSE role end = CASE WHEN @role IS NULL THEN '1' ELSE @role endPlease Whitelist JSFiddle in your content blocker.
Help keep JSFiddle free for always by one of two ways:
- Whitelist JSFiddle in your content blocker (two clicks)
- Go PRO and get access to additional PRO features →