CREATE PROCEDURE ex_proc (@part nvarchar(128), 
           @Num nvarchar(128), @Name nvarchar(256), 
           @ReqName nvarchar(256), @Email nvarchar(128)) 
AS INSERT INTO sample (part, Num,Name, ReqName, Email) VALUES ( @part, @Num, @Name, @ReqName, @Email) 
GO