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
-----------------------------------------------