need stored procedure

create procedure p_name
as
begin
       update tablename
                  set salary= case
                                     when salary< 5000 then salary * 1.1
                                     else salary
end
end

Jignesh Trivedi13y ago

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 Lenka13y ago

you can use this :

CREATE PROCEDURE hike
AS
BEGIN
UPDATE yourtablename
SET NetPay = CASE
WHEN Salary < 5000 THEN Salary * 1.1
ELSE Salary
END
END