| |
|
What is a Stored Procedure in SQL? Write the syntax for a Stored Proc.
A Stored Procedure is a set of instructions saved for invoking repeated execution. A procedure
may be used to handle a set of business logic to be performed. Say we want to insert
a record in a table, this type of a scenario is repeatitive and hence a stored procedure may
take care of this requirement. Further, the stored procedure may be passed parameters by the calling
routine, and so it may be reusable. Below is the syntax to create a procedure:
SQL Queries
SQL
Create Table
DDL, Create, Alter, Drop commands
DML, Select, Insert, Update, Delete
Create Database
ACID Rules
Dual Table
NULL
Join, Inner, Outer, Left, Right, Full, Cartesian, Natural, Equi
Table, View and a Synonym?
Execute
Function
Stored Procedure
Syntax Stored Proc
Stored Procedure Vs. Function
| |