there is table1 with coulmnA,coulmnB,coumnC,coulmnd and
there is table2 with coulmn1,coulmn2
and my procedure is
create procedure Detail
as
@cardtape VARCHAR(100),
@device varchar(10)
update table1
set coulmnB=@cardtape,coulmnC=@devid
i have to write trigger on table2 after insert the inserted value of coulmn1 and coulmn2
will the stored procedures @cardtype and @device value
that means it should be like
exec procedure Detail @cardtype,@device
where the value of @cardtype,@device will be inserted values of table2
that means whenever data is inserted in table2 and that value has to be used to process the store procedure