Sybase Stored Procedure

Stored procedure is named collection of SQL statements. We can create stored procedures to increase the performance. Sybase provides system procedures(predefined procedures) to perform administrative tasks.

Stored Procedure Syntax:

create procedure [owner.]procedure_name[;number] [[(]@parameter_name datatype [(length) | (precision [, scale ])] [= default] [output] [, @parameter_name datatype [(length) | (precision [, scale])] [= default] [output]]...[)]] [with recompile] as {SQL_statements | external name dll_name}

Examples:

Powered by k2schools