Passing multiple NULL and Value to Where clause in SQL Server

Hi nauna,

For this you have to check the input parameter with IS NULL condition.

Check this sample query and correct your query based on your table structure.

Database

For this example I have used of Northwind database that you can download using the link given below.

Download Northwind Database

SQL

DECLARE @OrderId INT, @EmployeeId INT, @ShipVia INT
SET @OrderId = NULL
SET @EmployeeId = 6
SET @ShipVia = 1

SELECT OrderID,EmployeeID,ShipVia,Freight,ShipCity FROM Orders
WHERE (OrderID = @OrderId OR @OrderId IS NULL)
AND (EmployeeID = @EmployeeId OR @EmployeeId IS NULL)
AND (ShipVia = @ShipVia OR @ShipVia IS NULL)