community.borland.com

Article #25177: How to create a stored procedure.

Problem:
How to create a static query to exist and be optimized on the
server for repeated usage.
Problem: I dont know how to create a stored procedure.

Solution:
Example:
	SET TERM !!;
	CREATE PROCEDURE my_procedure
	RETURNS (a_value INTEGER)
	AS
	BEGIN
		
	SELECT count(*) FROM table_name;
			
	END !!
		
	SET TERM ;!!

Use the Stored Procedure:
	SELECT * FROM my_procedure

Last Modified: 29-SEP-00