Name |
Value |
Schema |
[HumanResources] |
Owner |
[dbo] |
Creation date |
16.11.2015 |
Encrypted |
|
Disabled |
|
ID |
861246123 |
Implementation type |
Transact SQL |
Name |
Value |
QUOTED_IDENTIFIER |
ON
|
ANSI_NULLS |
ON
|
Instead of |
Insert |
Update |
Delete |
 |
|
|
 |
Name |
Value |
MS_Description |
INSTEAD OF DELETE trigger which keeps Employees from being deleted. |
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [HumanResources].[dEmployee] ON [HumanResources].[Employee]
INSTEAD OF DELETE NOT FOR REPLICATION AS
BEGIN
DECLARE @Count int;
SET @Count = @@ROWCOUNT;
IF @Count = 0
RETURN;
SET NOCOUNT ON;
BEGIN
RAISERROR
(N'Employees cannot be deleted. They can only be marked as not current.', -- Message
10, -- Severity.
1); -- State.
-- Rollback any active or uncommittable transactions
IF @@TRANCOUNT > 0
BEGIN
ROLLBACK TRANSACTION;
END
END;
END;
GO
EXEC sp_addextendedproperty N'MS_Description', N'INSTEAD OF DELETE trigger which keeps Employees from being deleted.', 'SCHEMA', N'HumanResources', 'TABLE', N'Employee', 'TRIGGER', N'dEmployee'
GO
|