title: Insert stored procedure passing parameter
body: <p>I have this SQL statement</p>
  
  <pre><code>INSERT housingSurvey ([nameID], [houseID], [jobID], [Active], [comment], [needsMaintenance], [lastUpdateDate) 
  VALUES (@NAMEID, @HOUSEID, @JOBID, 1, @DUEDATE, @COMMENT, NULL, @LASTUPDATEDATE)
  </code></pre>
  
  <p>I tried this stored procedure, but I don't get the current date.</p>
  
  <pre><code>CREATE PROCEDURE housingSurveyS(
                      @NAMEID INT,
                      @HOUSEID INT,
                      @JOBID INT, 
                      @COMMENT BIT,
                      @DUEDATE NVARCHAR,
                      CURRENTTIME)
  AS
  BEGIN
  INSERT INTO housingSurvey(
      [nameID],
      [houseID],
      [jobID],
      [Active],
      [comment],
      [dueDate],
      [needsMaintenance],
      [lastupdatedate])
  VALUES (
      @NAMEID,
      @HOUSEID,
      @JOBID,
      1,
      @COMMENT,
      @DUEDATE,
      NULL,
      @LASTUPDATEDATE)
  END
  </code></pre>
  
  <p>Could you please take a look at what I did wrong. Thanks</p>
  
  <p><strong>UPDATE</strong>
  I changed it CURRENTTIME to DATETIME as parameter to insert current date to [lastupdatedate]... it still doesn't work...</p>