title: Easy way of creating a stored procedure
body: <p>I want to ask about tricks for creating a stored procedure.</p>
  
  <p>When I try to create the procedure, I have to write the fields at the beginning of the <code>@</code> sign - so I do not have an easy way to do this?</p>
  
  <p>Like this </p>
  
  <pre><code>CREATE PROCEDURE [dbo].[Insert_Vehicle_Procedure]
      (@VehiclePlateNo varchar(max),
       @Variety varchar(max)
      )
  AS
      SET NOCOUNT OFF
  
      INSERT INTO [dbo].[Vehicles] ([VehiclePlateNo], [Variety])
      VALUES (@VehiclePlateNo, @Variety)
  </code></pre>
  
  <p>Sometimes there are hundreds of areas to write them can be really annoying :)</p>