Usar parametros en sentencia de sql: IS NULL

[juantiva]

Utilizando la base de datos Northwind, cambia tu query por algo así:


USE Northwind
GO

update orders set EmployeeID = NULL where orderID = 10248

DECLARE @ID as nchar
SET @ID = NULL
select * from orders where ISNULL(EmployeeID,0) = CASE WHEN @ID IS NULL THEN 0 ELSE @ID END

Suerte