Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- 4
- CREATE PROCEDURE zwiększenie_płacy_dla_stanowiska( @id_dzialu int, @procent float)
- AS
- BEGIN
- UPDATE employees e set e.salary = e.salary+e.salary*0.10*@procent where e.department_id = @id_dzialu and e.salary in (select j.min_salary from jobs j where j.job_id=e.job_id);
- END
- GO
- exec zwiększenie_płacy_dla_stanowiska(10, 20.0);
- GO
- drop procedure zwiększenie_płacy_dla_stanowiska
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement