Easy way of creating a stored procedure
<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>