Database

INSERT INTO EmpDetails (EmpName,EmpAge)<br />
VALUES ('XYZ',55)<br />
<br />
SELECT @@IDENTITY AS 'Identity'

CREATE TABLE example
(
    [ID] bigint IDENTITY (1, 1)
)

CREATE PROCEDURE dbo.sp_GetDowntime 
  @date SMALLDATETIME,
  @dept NVARCHAR(3), 
  @equip NVARCHAR(25),
  @shift NCHAR(1) 
AS BEGIN
  SET NOCOUNT ON

  SELECT h.oee_date, h.dept, h.equip, h.oee_shift, d.dt_reason,
        r.name, d.min
    FROM userdata_header h 
    INNER JOIN userdata_downtime d
      ON h.dept = d.dept
      AND h.oee_date = d.oee_date
      AND h.equip = d.equip
      AND h.oee_shift = d.oee_shift 
    INNER JOIN refer_dt r
      ON d.dt_reason = r.dt_reasonID
    WHERE h.oee_date = @date
    AND h.dept = @dept
    AND h.equip = @equip
    AND h.shift = @shift

  RETURN (0)
END

• The parameters needed commas between them.
  
• There was a comma in the where-clause.
  
• The "equip" link between the two tables specified the table-names instead of the table aliases.
  
• I added "Set Nocount On" because many front-end programming languages by SQL-Server results otherwise.