• 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