STORED PROCEEDURE
1. HOW DO YOU WRITE A STORED PROCEEDURE TO LIST NAMES BEGINNING WITH PARTICULAR STRINGS, SUPPLIED BY THE CALLER OF THE PROCEEDURE
2. HOW DO YOU WRITE A STORED PROCEEDURE TO APPLY SALARY INCREASES TO EMPLOYEES IN A GIVEN DEPT AND GRADE. THE CALLER OF THE PROCEEDURE TO SPECIFY THE PERCENTAGE INCREASE AND DEPT, E.G '7' FOR A 7% INCREASE. THE PROCEEDURE SHOULD UPDATE APPROPRIATE ROWS IN DATABASE AND LIST DETAILS OF EMPLOYEES WITH OLD AND NEW SALARIES.
LOADS OF THANKS TO ANYONE WHO WILL HELP ME OUT WITH THESE QUESTIONS
Last edited by VEENEE; May 14th, 2012 at 06:25 PM..
|