Previous | Home | Next |
Guideline
- Identify the database in which the stored procedure has to be created
- Determine the type of stored procedure
- Determine the name for the stored procedure
- Write the batch statement
CREATE PROCEDURE proc_name AS BEGIN sql-statement 1 sql-statement 1 END
where, proc_name specifies the name of the stored procedure.
Example
CREATE PROCEDURE empNameList AS BEGIN SELECT 'Employee'=emp_name, 'Salary'=emp_sal FROM employee END
Stored Procedure Created.
Check the existence of the procedure in the database
Syntax
sp_helptext proc_name sp_helptext empNameList
output
Execute the procedure
EXECUTE proc_name EXECUTE empNameList
output
Previous | Home | Next |