simransuri -4 hey!
i need to create a customised table "Employee" in which i have to insert employeeid,employeename and salary...on inserting the salary,the table should automatically calculate Hra(10% of basic salary),DA(9% of basic salary) and hence calculate net salary...so...plz guide me...how to do this?
smantscheff 265 how to do this
Don't. Do not store calculated values in your database. If Hra and DA are percentages of another database field, create a view which calculates them instead of storing them.
simransuri -4 but how can i calculate values in a view???
can u plz show me thru some example...plz...i need to complete this by today otherwise my teacher will screw me...plz guide me
debasisdas 580 You need to crate a view and add the calculated values as columns.
HRA = salary * 10/100
DA = salary * 9 /100
net = HRA + DA
Edited by debasisdas: n/a
simransuri -4 i still didnt get u...need an example...plz read my above query carefully
smantscheff 265 create view xyz as
select *, salary * 10 / 100 as HRA, salary * 9/100 as DA, salary * 19/100 as net from employees