how to store value into two tables at a time

Your question is unclear, but the way it is I'd give you a warning: don't store the same value in two tables, it'll eventually lead to inconsistent data. Instead, use one dedicated table to store data and reference it in other tables.

Hi,
You Can Use trigger here .................

1)write trigger in table tfn...
1)once you insert into table tfn.......trigger will get executed and and you can insert that value from tfn to another table.

Refer this for Triggers
Triggers -- Sql Server[^]

Refer these:

how to store a same values in two tables?[^]

You can Use triggers,
StoredProcedures,
And transactions
to do this.
but As my friend Timberbird mentioned, dont use same data in two different tables as it reduces the dataIntigrity.. Use transactions if you really wants that..

By using trigger you can insert value in two table at a time.
I have explained bellow how to use trigger.

Quote:

----------------------------------------
create table Table1(name varchar(50))

create table Table2(name varchar(50))

-----------------------------------------
create trigger insert_data on Table1
for insert
as
begin
declare @name varchar(50)
select @name =name from inserted
insert into Table2(name) values(@name)
end

---------------------------------------------

insert Table1(name) values('Purnananda Behera')

----------------------------------------------------

select * from Table1

select * from Table2
-----------------------------------------------