need stored procedure

Question

Hii ... Iam abhilash .. we have four feilds like EmpidnamesalaryNetpay who earn i nees stored procedure this is my mail id: abhim1607@gmail.com thank you

Sanjeeb Lenka · Answer

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

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 I think this duplicate post of http://www.c-sharpcorner.com/Forums/Thread/220269/need-help-about-stored-procedure.aspx so can please close it?