Stored Procedures||How to Pass NULL values as parameters in Stored Procedure?

Create Procedure spUpdateSal
@id INT,
@newsal DECIMAL(10,2) = NULL
AS
BEGIN
UPDATE emp
SET salary = ISNULL(@newsal,salary)
WHERE EMPID=@id;
END
EXEC UpdateSalary @EmpId = 1, @NewSalary = 55000.00;
EXEC UpdateSalary @EmpId = 2;
EXEC spUpdateSal 3,NULL

Видео Stored Procedures||How to Pass NULL values as parameters in Stored Procedure? канала LearnSQLtoSSIS