是SQL Server2008,有一个触发器,但里面没有回滚
触发器如下:
ALTER trigger [dbo].[trg_del] on [dbo].[drv_user]
instead of delete
AS
BEGIN
declare @cou int
select @cou=count(*) from deleted;
if (@cou>0)
RAISERROR('数据不允许删除!', 16, 1)
END[/quote]
@cou>0 --只要是删除就已经被拒绝了哦。
是SQL Server2008,有一个触发器,但里面没有回滚
触发器如下:
ALTER trigger [dbo].[trg_del] on [dbo].[drv_user]
instead of delete
AS
BEGIN
declare @cou int
select @cou=count(*) from deleted;
if (@cou>0)
RAISERROR('数据不允许删除!', 16, 1)
END
确实有个触发器,但没有ROLLBACK语句
触发器如下:
ALTER trigger [dbo].[trg_del] on [dbo].[drv_user]
instead of delete
AS
BEGIN
declare @cou int
select @cou=count(*) from deleted;
if (@cou>0)
RAISERROR('数据不允许删除!', 16, 1)
END