CREATE PROCEDURE < _ >
[{@_ _ }
AS
BEGIN
SELECT <__>
END
GO
DROP PROCEDURE {_}
EXEC <_> [@_=]{}
SQL-, .
, , . . . . .
:
, , , , ;
, , ;
, ;
;
.
CREATE TRIGGER < _ >
ON < _ >
AS
BEGIN
{ [ DELETE] [,] [ INSERT] [,] [ UPDATE] }
<_>
END
DROP TRIGGER {_}
AFTER. . - , . , : , .
INSTEAD OF. . INSTEAD OF- , .
:
INSERT TRIGGER INSERT. INSERT inserted , ; deleted ; inserted .
UPDATE TRIGGER UPDATE. UPDATE deleted , . inserted. .
|
|
DELETE TRIGGER DELETE. DELETE deleted , ; , ; inserted .
-
- : .
-:
■ . , , (IBM, DEC, Apple .) - ;
■ . , . ;
■ ( , , , )
■ . - .
- 4 :
1. .
2. , (, , ..) -.
3. ( , ..).
4. , .
, :
( 1- );
( 2- );
( 3- ).