manjula d

manjula d

  • NA
  • 172
  • 139.9k

my update stored procedure is not working

Jul 8 2013 8:05 AM
i got this error:

Procedure or function 'consultant_Update' expects parameter '@Consultant_Id', which was not supplied.



create procedure consultant_Update
(

@name varchar(50),
@Phone_Number varchar(50),
@Address varchar(50),
@City varchar(50),
@State varchar(50),
@Zip_Code varchar(50),

)

AS
BEGIN
update consultant set
name = @name,
Phone_Number = @Phone_Number,
Address =@Address,
City = @City,
State = @State,
Zip_Code = @Zip_Code where Consultant_Id = @Consultant_Id   
END

GO




Answers (17)