how to give a variable name of trigger as table name in INSERT QUERY of TRIGGER?..
create trigger tg on TABLE_NAME
Declare @var;
select @var=i.tg from inserted i;
insert into '+@var+' values('xzxcvdf','dvfdf');
go
i Got a error on this.....Anyone can help me
Loading
Akkiraju IvaturiPosted Sep 14, 2012, 8:36 AM