Need help about stored procedure

Question

Hi... Iam abhilash .. suppose we have 4 fields .. like Empid NameSalaryNetPay.. who's employees earn i need stored procedure ....

Iftikar Hussain · Answer

Hi Try like this update Emptable set Netpay=CASE WHEN salary ELSE Netpay end Regards Iftikar

Pankaj Pandey · Answer

create procedure p_name as begin update tablename set salary= case when salary else salary end end

Jignesh Trivedi · Answer

hi try CREATE PROCEDURE TempSP AS BEGIN update Table1 set NetPay = salary + (salary *10)/100 where salary END hope this will help you.

Sanjeeb Lenka · Answer

you can use this : CREATE PROCEDURE hike AS BEGIN UPDATE yourtablename SET NetPay = CASE WHEN Salary ELSE Salary END END