Simple and sample Storedprocedure

Simple and sample Storedprocedure......
-- =============================================
-- Author: Raja
-- Create date: 03-08-2011
-- Description: Sample user Storedprocedure
-- =============================================
CREATE PROCEDURE USP_Sample
-- Add the parameters for the stored procedure here
@sno numeric(10),
@sname nvarchar(50)
AS
BEGIN

    -- Insert statements for procedure here
INSERT INTO SAMP(SNO,SNAME) VALUES (@sno ,@sname )

END


EXEC USP_Sample 1,'RESOURCES'