How to implement trigger on table
i have one table having fields(empno,empname,emaild).how to create trigger if i did any insert,delete transactions on this table.
Advance thanks,
sowjanya.
CREATE TABLE [dbo].[T1](
[id] [int] IDENTITY(1,1) NOT NULL,
[name] [varchar](50) NULL,
[address] [varchar](500) NOT NULL,
[companyname] [varchar](100) NOT NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[T2](
[Id] [int] IDENTITY(1,1) NOT NULL,
[type] [varchar](50) NULL
) ON [PRIMARY]
Now i want to enter for each insert, update, delete operation on T1.
so craete trigger on T1.
CREATE TRIGGER [dbo].[TriT1] on [dbo].[T1] for insert, update, delete
as
declare @insRecord int,@Type char(8) ,@delRecord int
BEGIN
SET NOCOUNT ON;
select * into #ins from inserted
select * into #del from deleted
select @insRecord = count(1) from #ins
select @delRecord = count(1) from #del
if @insRecord > 0
if @delRecord > 0
select @Type = 'Update'
else
select @Type = 'Create'
else
select @Type = 'Delete'
-- Insert statements for trigger here
if @insRecord >0 or @delRecord >0
begin
insert into T2 values (@Type )
end
END
GO