may be stored procedure.
Posted on 2014-01-22
I Have Table T1(A,B,C) and I have a Table t2(D,E,F).
when ever i want to insert on table t1 in coulmn A,B,C. I want to insert it into table T2 same value for clumns in T1 + may be appending some additional value to table t2 or .
what would be the best approach and can i sample code for it.
if insert (USA,UK,IND) in to T1 i need to pass values and append 001 for USA and 044 to uk and 091 to IND and it should insert like (USA001,UK044,IND091).
in above example 001,044,091 should be any value i want to append it to the value in table T1.