Welcome to Sign in | Help

Script stergere in cascada

  •  11-06-2009, 5:19 PM

    Script stergere in cascada

    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.
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems