NumTrigger.sql

CREATE TRIGGER [dbo].[NumTrigger]
ON [dbo].[testTable]
FOR UPDATE
AS
BEGIN
	print 'begin trigger'
	if UPDATE(Num)
	BEGIN
			DECLARE @num int 
			select @num=Num from inserted
			print 'inserted num:' + cast(@num as nvarchar)
			if @num>5
			BEGIN
			  print 'raiseerror in trigger'
				RAISERROR('Error:Trigger', 16, 2)
				rollback
			End
	End
END