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::🌲