:
EXECUTE PROCEDURE [ [, ] ];
[ RETURNING_VALUES [, ] ];
:
EXECUTE PROCEDURE AVG_KOLVO (:IN_TOVAR)
RETURNING_VALUE:AVG_KOLVO_TOVAR;
POST_EVENT
- , .
POST_EVENT ;
. , EVENT INIT.
. , , , . , . , - .
:
ALTER PROCEDURE
[ (_ _
[, _ _ ]) ]
[ RETURNS
(_ _
[, _ _ ]) ]
AS
< >
:
DROP PROCEDURE
- , , . , . , , . , . , , . , - . , , , , - , . , , - , , , .
:
, , :
|
|
:
:
, .
.
-, .
. , , .
:
CREATE TRIGGER FOR
[ ACTIVE | INACTIVE ]
{ BEFORE | AFTER }
{ DELETE | INSERT | UPDATE }
[ POSITION ]
AS
[< >]
BEGIN
<>
END
, . OLD NEW.
:
ACTIVE | INACTIVE , . , INACTIVE. ACTIVE.
BEFORE | AFTER , (BEFORE) (AFTER) .
DELETE | INSERT | UPDATE , .
POSITION , .
.
):
CREATE TRIGGER AD_TOVARY FOR TOVARY
ACTIVE
AFTER DELETE
POSITION 1
AS
BEGIN
DELETE FROM RASHOD
WHERE RASHOD.TOVAR = TOVARY.TOVAR;
END
OLD NEW
OLD._ , , NEW._ , .
:
CREATE TRIGGER BU_TOVARY FOR TOVARY
ACTIVE
BEFORE UPDATE
AS
BEGIN
IF (OLD.TOVAR <> NEW.TOVAR) THEN
UPDATE RASHOD
SET TOVAR = NEW.TOVAR
WHERE TOVAR = OLD.TOVAR;
END
3.6.4. :
ALTER TRIGGER FOR
[ ACTIVE | INACTIVE ]
{ BEFORE | AFTER }
{ DELETE | INSERT | UPDATE }
[ POSITION ]
AS < >
3.6.5. :
DROP TRIGGER