Example for creating a simple stored procedure

Example:

Create a simple stored procedure to fetch complete data from STUDENT table.

Query:

CREATE PROC STUDENT_DATA

AS

BEGIN

      SELECT * FROM STUDENT

END