title: Procedure expects parameter which was not supplied in SQL
body: <p>I'm getting this error when accessing a stored procedure in SQL Server:</p>
  
  <blockquote>
    <p>Procedure or function 'resetdata' expects parameter '@FirstName', which was not supplied.</p>
  </blockquote>
  
  <p>This is my table:</p>
  
  <pre><code>CREATE TABLE dbo.Client
  (
      ClientID int IDENTITY(1,1) PRIMARY KEY NOT NULL, 
      FirstName VARCHAR(50) NOT NULL,
      LastName VARCHAR(50) NOT NULL,
      StreetAddress VARCHAR(50) NULL,
      Suburb VARCHAR(15)NULL,
      C_State VARCHAR(3) NULL, --CHECK (C_State IN ('QLD', 'NSW', 'VIC', 'TAS', 'SA', 'WA', 'NT', 'ACT')), 
      PostCode SMALLINT NOT NULL, 
      PhoneNumber VARCHAR(11) NULL, 
  );
  GO
  
  ALTER TABLE Client
  ADD CONSTRAINT state_ CHECK (C_State IN ('QLD', 'NSW', 'VIC', 'TAS', 'SA', 'WA', 'NT', 'ACT')),
      CONSTRAINT check_post_code CHECK ([PostCode] LIKE '[0-9][0-9][0-9][0-9]' or [PostCode] LIKE '[0-9][0-9][0-9]');
  GO
  </code></pre>
  
  <p>This is my stored procedure:</p>
  
  <pre><code>CREATE PROCEDURE [dbo].[resetdata]
      @FirstName varchar(50),
      @LastName varchar(50),
      @PostCode smallint
  AS
  BEGIN
      INSERT INTO A1.dbo.Client (FirstName, LastName, PostCode)
      VALUES(@FirstName, @LastName, @PostCode)
  END;
  GO
  
  EXEC dbo.resetdata;
  INSERT INTO Client(FirstName, LastName, PostCode) 
  VALUES ('F', 'L', 12345); 
  </code></pre>