Listing 2: Creating Stored Procedure usp_upd_Employees

IF OBJECT_ID('dbo.usp_upd_Employees', 'P') IS NOT NULL
  DROP PROC dbo.usp_upd_Employees;
GO
CREATE PROC dbo.usp_upd_Employees
  @empid     AS INT,
  @firstname AS VARCHAR(20) = NULL,
  @lastname  AS VARCHAR(20) = NULL,
  @salary    AS MONEY       = NULL
AS

IF (    @firstname IS NULL
    AND @lastname  IS NULL
    AND @salary    IS NULL )
  RETURN;

UPDATE dbo.Employees
  SET firstname = COALESCE(@firstname, firstname),
      lastname  = COALESCE(@lastname, lastname),
      salary    = COALESCE(@salary, salary)
WHERE empid = @empid;
GO





1