Msg 208, Level 16, State 3, Procedure AddRegistrationFormNew

Question

USE [Sams]

GO

/****** Object:  StoredProcedure [dbo].[AddRegistrationFormNew]    Script Date: 07/29/2013 09:46:50 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[AddRegistrationFormNew]( @Name VARCHAR(15),@Address VARCHAR(30),@PhoneNumber INT,@EmailId VARCHAR(15))

AS 

declare @Rid as int

select @Rid =ISNULL( max(Rid),0)from AddRegistrationFormNew

set @Rid=@Rid+1;

INSERT INTO RegistrationFormNew(Rid,Name,Address,PhoneNumber,EmailId)VALUES(@Rid,@Name,@Address,@PhoneNumber,@EmailId)

EXEC AddRegistrationFormNew 'test','palak','100','[email protected]'