update the record into database using store procedure

Hi Kashif,

I think you forgot to pass @Id parameter. You can change your parameter as optional.

Your procedure handle unpassed parameters also.

How to make parameters as optional in storedprocedures?

I will take one scenario to explain to avoid this type of error in Storedprocedure.

I have one table named employee to maintain employee detail.

I write only one procedure to do CURD operations.

Scenarios:

In insert, the record do not need to pass Identity(Auto) value.

In update, do not need to pass all values of table, only pass modified values.

In select, only primary key is enough to get particular value.

Find below Storeprocedure to achieve this scenario.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P8y ago
hi,

I think you have forgot to pass parameter @id value to procedure Updatedata, thats why you are getting this error
Packiaraj Santhiyagu8y ago
Hi Kashif,

I think you forgot to pass @Id parameter. You can change your parameter as optional.

Your procedure handle unpassed parameters also.

How to make parameters as optional in storedprocedures?

I will take one scenario to explain to avoid this type of error in Storedprocedure.

I have one table named employee to maintain employee detail.

I write only one procedure to do CURD operations.

Scenarios:

In insert, the record do not need to pass Identity(Auto) value.

In update, do not need to pass all values of table, only pass modified values.

In select, only primary key is enough to get particular value.

Find below Storeprocedure to achieve this scenario.
create proc usp_employee
(
    @flag char(5)=null,
    @id int=null,
    @empname varchar=null
)
as
begin
    if(@flag='in')
    begin
        insert into your_tableanme(s_Name)values(@empname)
    end
    if(@flag=='sel')
    begin
        select * from your_tablename where id=@id;
    end
end
Yogesh Ghorpade8y ago
Please Check Your Store Procedure Parameter And
Your Methods Parameter Or Share Your SP Code And Method