need stored procedure

Question

Hi...

Iam abhilash ..

suppose we have 4 fields .. like Empid ,Name,Salary,NetPay..

who's employees earn < 5000 salary those people get 10% comission so that employees salary +comission ..updated into NetPAy column in same table four fields..

i need stored procedure ....

this is my mail id ..

[email protected]

thank you...

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 so please mark asd close http://www.c-sharpcorner.com/Forums/Thread/220269/need-help-about-stored-procedure.aspx

Sanjeeb Lenka · Answer

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