How to insert data using triggres?

See more:

SQL-Server-2008R2

Hi i am new to this topic triggres.here i am having i was created tables like this shown below


table1:student

id name dept gender marks


table2:studentdetails


name dept gender marks fathername mothername address


table 3: studentpersonal

fathername mothername address


for student table i worte trigger program like this

craete stdtrg
on student
After insert,uoadate,delete
as
begin

set unccont on;
declear @name varchar(50),
@dept varchar(50),
@gender vacahar(50),
@marks int;

select @name=name,@dept=dept,@gender=gender,@marks=marks from student

select @name,@dept,@gender,@marks from inserted

insert into studentdetails([name],[dept],[gender],[marks])values(@name,@dept,@gender,@marks)

end

for studentpersonal table also i worte trigger program like this.

declare @fathername varchar(50),
@mothername varchar(50),
@address varchar(50);


select @fathername=fathername,@mothername=mothername,@address=address from studentpertsonal


select @fathername,@mothername,@address from inserted


insert into studentpersonal([fathername],[mothername],[address])values(@fathername,@mothername,@address)


command sucessfuly i got both program when i was execute

now i want to see o/p.first i when t o student table right clik on it. select to 200 row i click
and i was inserted one row like this

1 xx maths male 50

1 row effected

same thing was done to studentpersonal table i was inserted row like this

venky sheela hyd

one row effeted

i click on studentdetails right click edit top 200 rows and open. then o/p was shown like this


xx maths male 50 null null null
null null null null venky sheela hyd



i want o/p like this



xx maths male 50 venky sheela hyd


i want to dispaly all in one row .please help me .