Welcome to
Sign in
|
Help
in
Intrebari generale (forum)
Romanian Section (group)
(Entire Site)
Search
Home
Blogs
External Feeds
Forums
Photos
Downloads
About Us
»
Romanian Section
»
Intrebari
»
Intrebari generale
»
Re: Script stergere in cascada
Script stergere in cascada
Last post 11-18-2009, 2:46 PM by
creieru
. 4 replies.
Sort Posts:
Oldest to newest
Newest to oldest
Previous
Next
11-06-2009, 5:19 PM
7800
werty80
Joined on 11-06-2007
db_owner
Script stergere in cascada
Reply
Quote
Am doua tabele A,B care arata cam asa:
Tabela A Tabela B
PlanId InfNo PlanId InfNo ContactId
1000 41 1000 41 50
1000 42 1000 42 53
1001 10 1001 10 55
1001 11 1001 11 57
M-ar interesa un script care sa actioneze ca o stergere in cascada(Ex daca sterg linia 1 din tabela B sa imi stearga automat din tabela A linia care contine acelasi PlanId si InfNo ). NU pot sa folosesc pk si fk pentru ca am inregistrari identice.
Report abuse
11-07-2009, 12:48 PM
7806
in reply to
7800
B_gd_n[ ]Sahlean
Joined on 07-17-2007
Bucuresti
sysadmin
Re: Script stergere in cascada
Reply
Quote
werty80:
... NU pot sa folosesc pk si fk pentru ca am inregistrari identice.
Detaliază ...
Report abuse
11-08-2009, 10:45 PM
7810
in reply to
7806
werty80
Joined on 11-06-2007
db_owner
Re: Script stergere in cascada
Reply
Quote
Pai mai detaliat de atat , deci daca sterg o inregistrare din tabela B sa imi stearga inregistrarea coresp. PlanId si InfNo din tabela A. M-ar ajuta si o sintaxa de parcurgere a inregistrarilor ceva asemanator "for".
Report abuse
11-09-2009, 11:55 AM
7811
in reply to
7810
B_gd_n[ ]Sahlean
Joined on 07-17-2007
Bucuresti
sysadmin
Re: Script stergere in cascada
Reply
Quote
CASCADE DELETE
Report abuse
11-18-2009, 2:46 PM
7830
in reply to
7800
creieru
Joined on 11-24-2008
db_datawriter
Re: Script stergere in cascada
Reply
Quote
pt tabela A creezi un composite primary key
pt Tabela B creezi un foreign key
alter table TabelaA add primary key (PlanID, InfNo)
alter table TabelaB add foreign key (PlanID, InfNo) references Tabelaa (PlanID, InfNo)
apoi modifici foreign key-ul creat cu delete rule -> cascade
Report abuse