title: I got an error in my stored procedure at DECLARE
body: <p>I learn to use stored procedure for insert, but I get this error </p>
  
  <blockquote>
    <p>incorrect syntax near DECLARE </p>
  </blockquote>
  
  <p>I don't understand much about syntax, please help to correct it and explain it for me too; </p>
  
  <pre><code>USE P_DETAIL
  
  CREATE PROCEDURE PRO_INSERT DECLARE 
  @ST_ID int,
  @ST_NAME NVARCHAR(50),
  @ST_SEX NVARCHAR(10),
  @ST_DOB DATE,
  @ST_AGE INT,
  @ST_POSITION NVARCHAR(30),
  @ST_ADDRESS NVARCHAR(60),
  @ST_PHONE INT,
  @SV_ID INT,
  BEGIN
  
  INSERT INTO TBL_STAFF
  (
  ST_ID ,
  ST_NAME ,
  ST_SEX ,
  ST_DOB ,
  ST_AGE ,
  ST_POSITION ,
  ST_ADDRESS ,
  ST_PHONE ,
  SV_ID 
  )
  VALUES
  (
  @ST_ID ,
  @ST_NAME ,
  @ST_SEX ,
  @ST_DOB ,
  @ST_AGE ,
  @ST_POSITION ,
  @ST_ADDRESS ,
  @ST_PHONE ,
  @SV_ID 
  )
  
  END;
  </code></pre>