ALTER trigger [dbo].[TRIG_StopDelete_UtBFDiscussion]
on [dbo].[UtBFDiscussion]
for delete as
begin
declare @num_Deleted int
/* Determine how many rows were deleted. */
select @num_Deleted = @@rowcount
if @num_Deleted > 1
Begin
select ' Invalid Operation'
rollback transaction
End
else
Begin
select str(@num_Deleted) + ' row(s) Deleted'
End
End
--------------------------
ALTER trigger [dbo].[TRIG_StopUpdate_UtBFDiscussion]
on [dbo].[UtBFDiscussion]
for update as
begin
declare @num_updated int
/* Determine how many rows were updated. */
select @num_updated = @@rowcount
if @num_updated > 1
Begin
select 'Invalid Operation'
rollback transaction
End
else
Begin
select str(@num_updated) + ' row(s) Updated'
End
End
0 comments:
Post a Comment