1
Reply

INSERT QUERY of TRIGGER?..

Ask a question
sabari T

sabari T

12y
1.1k
1
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

Answers (1)