How to Have Conditional Where Clause Based on Parameter Value

Name: How to Have Conditional Where Clause Based on Parameter Value
Uploaded: 2026-09-27T11:04:36+00:00
Duration: 11 min 13 s
Description: I Have Following Sql, Declare @Employeeid Int Select * from [Northwind]. [Dbo]. [Orders] Where Orderid = 10248 and Employeeid = @Employeeid I Want to Make Sure...

Question

I have following SQL,

DECLARE @EmployeeID Int

SELECT *
  FROM [Northwind].[dbo].[Orders]
  WHERE OrderID = 10248
  AND EmployeeID = @EmployeeID

I want to make sure IF @EmployeeID IS NULL Then do not include AND

Something like,

SELECT *
  FROM [Northwind].[dbo].[Orders]
  WHERE OrderID = 10248
  IF @EmployeeID IS NOT  NULL
  AND EmployeeID = @EmployeeID

I could think of creating a table variable and then filtering them based on parameter value , but is there a better way?

Accepted Answer

I think you want:

WHERE OrderID = 10248 AND
      (@EmployeeId IS NULL OR EmployeeID = @EmployeeID)

Answer 2

DECLARE @EmployeeID Int

SELECT *
  FROM [Northwind].[dbo].[Orders]
  WHERE OrderID = 10248
  AND EmployeeID = ISNULL(@EmployeeID, EmployeeID )

How to Have Conditional Where Clause Based on Parameter Value

2 Answers

Must Read

Your Answer

Robert Thorne

How to Have Conditional Where Clause Based on Parameter Value

2 Answers

Must Read

Your Answer

Sign up or log in

Post as a guest

Robert Thorne