DATABASE SQL DAY 9) STORE PROCEDURE

 * STORE PROCEDURE IS SET OF OPERATION PERFORM IN A DATABASE.

 * STEP1 --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;