sql check if parameter is null in where clause

📅 2025-03-12 06:05:48 — 👀 62 — 👦 admin

SELECT * FROM Thingies WHERE ThingID = isnull(@ThingId, ThingID)
--or
SELECT * FROM Thingies WHERE (@ThingId IS NULL OR ThingID = @ThingId)