Add conditional check to a Stored Proc Query

• Language:: T-SQL
• Type:: Back-end Database
• Context:: This is so that can filter according to the parameter if it has been passed to the proc
• Description
• Snippet

-- Add the AND with the check or to add the conditional check to the proc query
WHERE FirstParameter = @FirstParameter
    AND (
        @Parameter = 0 OR (
            @Parameter != 0 AND (Parameter = @Parameter)
        )
    )

• Dependencies::

---

📇Additional Metadata

• 📁Type:: snippet
• 🏷️Tags:: Database, MS Sql
• 📡Status:: #status/🌲