, . , . . . , , - , , , , , . (DDL, Data Definition Language). , . , , , . . . , . , . , , . . , . , :1. ; 2. . , . :1. . ;2. , ;3. , . . . "--" - - .
|
|
|
33. SQL, , , SQL. , SQL . SQL :1. ;2. ; SQL Server , ;3. . , , ;
4. ;
5. ;
6. , , ;
7. : , . , , , .
, , . . , . , , .
, , : . , , . , .
- . , . , . . .
35. SQL, . , , , . , . SQL-, . , , . , :1. , 2. 1 () , . , . , . , . , proc mysql. . , , mysql.proc . CREATE PROCEDURE CREATE FUNCTION. , CALL, . . .MySQL , SELECT ( ) . , , . SELECT , , . CREATE PROCEDURE . CREATE FUNCTION . EXECUTE . :
|
|
|
CREATE PROCEDURE _ ([_[,...]])
[...] _
CREATE FUNCTION _ ([_[,...]])
RETURNS
[...] _
_:
[ IN | OUT | INOUT ] _
_:
_
:
MySQL
:
LANGUAGE SQL
| [NOT] DETERMINISTIC
| { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }
| SQL SECURITY { DEFINER | INVOKER }
| COMMENT 'string'
36. , , , . . , , , , . , , . SELECT, , . SQL Server : 1)Scalar , , BEGIN...END; 2)Inline SELECT TABLE; 3)Multi-statement TABLE, , SQL (INSERT, UPDATE ..). <__>{CREATE | ALTER } FUNCTION [.]
_([ { @_ __[=default]}[,...n]])
RETURNS __[WITH {ENCRYPTION | SCHEMABINDING}[,...n] ][AS] BEGIN
<_> RETURN _ END.
