--插入前触发器实现create trigger it_admin on admin instead of insert as if exists(select 1 from admin) begin rollback tran return end
用触发器 create trigger test_tr on dbo.test for insert as if exists(select 1 from inserted) begin raiserror 50001'禁止新增记录' rollback tran end
set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: Rocky -- Create date: 2007-01-15 -- Description: 禁止刪除辛辛苦苦建立起來的DB文檔 -- ============================================= Create TRIGGER [dbo].[TR_Sys_CanNotInsert] ON [dbo].[你的表名] FOR Insert AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON;
rollback -- Insert statements for trigger here RAISERROR ('禁止插入數據',11,1) return END
instead of insert
as
if exists(select 1 from admin)
begin
rollback tran
return
end
create trigger test_tr on dbo.test
for insert
as
if exists(select 1 from inserted)
begin
raiserror 50001'禁止新增记录'
rollback tran
end
set QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Rocky
-- Create date: 2007-01-15
-- Description: 禁止刪除辛辛苦苦建立起來的DB文檔
-- =============================================
Create TRIGGER [dbo].[TR_Sys_CanNotInsert]
ON [dbo].[你的表名]
FOR Insert
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
rollback
-- Insert statements for trigger here
RAISERROR ('禁止插入數據',11,1)
return
END