| Author: venu kumar 28 Aug 2008 | Member Level: Silver | Rating:  Points: 0 |
create trigger on the table with the condition
|
| Author: Ritesh N. Jain 28 Aug 2008 | Member Level: Gold | Rating: Points: 3 |
In case it's one time batch update,better use simple UPDATE startement rather than going for Trigger,
UPDATE Employee
SET
Salary = Salary * 1.1
|
| Author: http://venkattechnicalblog.blogspot.com/ 31 Aug 2008 | Member Level: Diamond | Rating: Points: 2 |
Yep, an update statement will do this.
Regards,
Venkatesan Prabu .J
http://venkattechnicalblog.blogspot.com/
|
| Author: palla 01 Sep 2008 | Member Level: Silver | Rating: Points: 3 |
hi
select employeeid,salary=case when salary>10000 then salary=salary+1000
when salary>20000 then salary=salary+2000
else
salary
end
from employee
this is easy way.
|