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

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

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

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

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?

Answers

need stored procedure

abhilash madhadi

11y

1.6k

Hii ...
Iam abhilash ..

we have four feilds like Empid,name,salary,Netpay,,,

who earn <5000 salary those people get 10% hike added to salary updated into Netpay column

i nees stored procedure

this is my mail id: [email protected]
thank you

Answers (4)

Next Recommended Forum

need stored procedure

Which query I use to fetch datetime column in SQL Server2000

Forum Statistics

Please welcome our newest member Priti Bhade.
3,083,931 users have contributed to 147,418 threads and 483,476
In the past 24 hours, we have 5 new threads, 19 new posts, and 84 new users.
In last week, the most popular thread is 'How to publish the Artifact to Local IIS ?'.

Upcoming Events

View all

Global Azure Bootcamp - Rasipuram
Software Architecture Conference - 2025