Have a fun while searching

Wednesday, July 21, 2010

tiggers for delete and update

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