PostDet.KLAV, S1 PostDet.tblSP.
:
USE Postavki;
GO
CREATE FUNCTION PostDet.KLAV
(
@NewPost CHAR(10)
)
RETURNS TABLE
AS
RETURN
(
SELECT DISTINCT QTY As NewQTY FROM PostDet.tblSP
WHERE PostDet.tblSP.S = @NewPost
);
. .
, SELECT .
-- PostDet.Klav.
USE Postavki;
GO
GRANT SELECT ON PostDet.Klav TO Fred;
. :
SELECT * FROM PostDet.Klav(S1);
S1.
PostDet.QTYSUM .
USE Postavki;
GO
CREATE PROCEDURE PostDet.QTYSUM
AS
DECLARE @NumPost char(10), @a char(7)
SET @NumPost = 'S1'
SET @a = (SELECT MAX(NewQTY) FROM PostDet.KLAV (@NumPost))
SELECT @a
.
Fred PostDet.QTYSUM.
USE Postavki;
GO
GRANT EXECUTE ON. PostDet.QTYSUM
TO[FS-64C67299CCAR\Fred];
Fred .
. : PostDet.QTYSUM;
S1.
.
, , DML, , DDL.
DML INSERT, UPDATE DELETE. , -. DDL , , , , CREATE, ALTER, DROP. , , .
SQL Server. , tblS.
:
USE Postavki
GO
CREATE TRIGGER PostDet. no_insert ON PostDet.tblS
For INSERT
AS
ROLLBACK;
. PostDet.tblS . . . Esc. DDL, , DROP_TABLE.
USE Postavki;
GO
CREATE TRIGGER trgDrp
ON DATABASE
FOR DROP_TABLE
AS
ROLLBACK;
. .
|
|
DISABLE TRIGGER PostDet.no_insert.
USE Postavki;
GO
DISABLE TRIGGER PostDet.no_insert ON PostDet.tblS;
ENABLE TRIGGER.
USE Postavki;
GO
ENABLE TRIGGER PostDet.no_insert ON PostDet.tblS;
DROP TRIGGER.
DROP TRIGGER trigger_name ON [Database]
.
, , . , , .
1. Postavki S3.
:
1 BEGIN TRANSACTION;
2 DELETE FROM PostDet.tblSP
3 WHERE S = S3;
DELETE FROM PostDet.tblS
5 WHERE S = S3;
6 COMMIT;
1 - .
2,3 - PostDet.tblSP.
4,5 PostDet.tblS.
6 . , COMMI T ( ). .
,
2. . S3 3 , . .
, Grids - ( 1). . .
1,
, .
1. .