SQL Server, , EXEC. Transact-SQL. :
- DML INSERT, UPDATE DELETE.
- DDL CREATE, ALTER, DROP.
, , ROLLBACK . ROLLBACK .
RAISEERROR .
INSERT
INSERT INSERT. SQLServer inserted.
: Sotrydnik Ludi. , 20000 .
1. SQL Server Management Studio. Object Explorer Ludi - Programmability Triggers.
2. Triggers NewTriggers.
3. :
CREATE TRIGGER primer1
ON sotrydnik
AFTER INSERT
AS
BEGIN
SET NOCOUNT ON;
if (select oklad from inserted)<'20000'
Rollback
print' 20 000 '
END
GO
4. , . Command(s) completedsuccessfully.
5. , Save
, , New Query ,
USE LUDI
INSERT SOTRYDNIK
VALUES (S28,,,,10000,2,1)
, , , .
, , , .
DDL.
DDL CREATE, ALTER, DROP ..
: , .
1. , New Query , :
USE LUDI
GO
CREATE TRIGGER CANTDROPSOTRYDNIK
ON DATABASE
FOR DROP_TABLE, ALTER_TABLE
AS
PRINT Ē
ROLLBACK
2. . , New Query ,
|
|
:
DROP_TABLES SOTRYDNIK
3. :
: ,