'Sql procedure' diaporamas de présentation

Stored Procedures & Functions

Stored Procedures & Functions. One or more SQL statements are grouped together to make a program or procedure. With the stored procedure, several capabilities normally associated with programming languages are available Some of these capabilities are:

791 views • 67 slides

Robert Catterall, IBM rfcatter@us.ibm

477 views • 39 slides

Basic SQL Procedure Structure

Basic SQL Procedure Structure. Unit objectives. After completing this unit, you should be able to: Describe the structure of an SQL procedure Explain various clauses of the CREATE PROCEDURE statement List the statements that can be coded in the procedure body Alter Procedure

407 views • 20 slides

The SQL Procedure

The SQL Procedure. Block of SQL statements stored in the Data dictionary and called by applications Satisfies frequently-used or critical application logic When called all code within the procedure is executed (unlike packages) Action takes place on server not client

143 views • 5 slides