TRIGGER IN SQL SERVER 2005 FOR INSERT

ALTER trigger [dbo].[InsertIntoTable]
on [dbo].[stud]
AFTER  Insert
as

Declare @val NVARCHAR(10)
select @val=(select name from inserted)

if (select count(*) from stud where name=@val) > 1
BEGIN
Print 'Data Already Exist'
--ERROR ( 'Data already has enterd' )
ROLLBACK TRAN
END

Share This