Stored Procedure in Database

p {margin: 0; padding: 0;} .ft00{font-size:18px;font-family:NimbusRomanBold;color:#000000;} .ft01{font-size:18px;font-family:NimbusRomanRegular;color:#000000;} DDL For Stored Procedure A stored procedure is a subroutine available to applications that access a relational database management system. Such procedures are stored in the database data dictionary. Uses for stored procedures include data-validation or access-control mechanisms. 1. Create CREATE PROCEDURE procedure_name AS BEGIN     -- SQL statements for the procedure END; 2. Alter ALTER PROCEDURE procedure_name AS BEGIN     -- Updated SQL statements for the procedure END; 3. Drop DROP PROCEDURE procedure_name;