Stored
Procedures
are
a
valuable
tool
for
improving
performance
in
distributed
and
networked
environments.
In
addition,
they
can
also
be
used
to
improve
the
flexibility
and
design
of
your
applications.
SQL
Stored
Procedures
offer
a
procedure
language
that
is
comparable
with
stored
procedure
languages
of
other
DB
Servers
such
as
Oracle
&
SQL
Server.
By
the
end
of
this
session,
attendees
will
be
able
to:
1.
How
to
create
and
invoke
an
SQL
Stored
Procedure.
2.
Understand
error
handling
techniques
in
SQL
Procedures.
3.
How
to
move
an
SQL
stored
procedure
into
production.
|