* STORE PROCEDURE IS SET OF OPERATION PERFORM IN A DATABASE. * STEP 1 --DATABASE--PROGRAMIBILITY--STORE PROCEDURE RIGHT CLICK--NEW STORE PROCEDURE--SELECT A AND ALL DELETED. * CREATE PROCEDURE COMMAND IS USED. *---CREATE ----* CREATE PROCEDURE EMPLOYEE AS BEGIN SELECT NAME,SALARY,ID FROM emp; END; * STEP2 --GO TO THE QUERY WINDOW AND EXECUTE COMMAND(USI DATABSE PE RIGHT CLICK KRKE QUERY RUN KRO). *--UPDATE--* ALTER PROCEDURE EMPLOYEE AS BEGIN SELECT NAME,SALARY,ID FROM emp; END;