Viewing 9 posts - 1 through 9 (of 9 total)
I need the another approach(other than trigger and update cascade)..If any Please do reply
February 2, 2011 at 3:22 am
Hi,
If there are many child tables which are reffering to the parent table then?
February 2, 2011 at 2:41 am
I got the answer with both the options . Is there any option other than Trigger,on update cascade
February 2, 2011 at 2:23 am
Hi,
create table dc(id int,doctor_name varchar(20),date datetime,patient_name varchar(20),medicine int)
insert into dc values(111,'dr.Smith','01/01/2010','Mr.Jerry',123)
insert into dc values(111,'dr.Smith','01/01/2010','Mr.Jerry',456)
insert into dc values(111,'dr.smith','01/01/2010','Mr.Jerry',678)
insert into dc values(112,'dr.smith','01/02/2010','Mr.kk',999)
insert into dc values(112,'dr.nn','02/02/2010','mr.kk',88)
select * from dc
select id,count(*)...
January 31, 2011 at 8:57 pm
Thanks Very much
January 24, 2011 at 4:29 am
Ya.. But how can we do the same with 1,2,3 empid's.
January 24, 2011 at 1:07 am
after inserting these two records to the previous records we need to get the result as:
insert into sales values(2011,01,100)
insert into sales values(2011,12,10)
ans:
20101110110
20102220330
20103330660
201044401100
201055501650
201066602310
201077703080
201088803960
201099904950
20101011006050
20101112107260
20101213208580
201111008680
201112108690
January 19, 2011 at 8:15 pm
Viewing 9 posts - 1 through 9 (of 9 total)