Re: OTHER BIG BUG : deleting detail master delete
Cavalera Guido skrev:
There is another simple way ?
If you have cascade delete on the foreign key relation between your
master and detail table in SQLServer you only have to delete and do
apply updates for the master dataset.
regards
/Micke
.
Relevant Pages
- Re: sqlserver 2000 - profiler problem!
... > master, msdb und model DB's mit denen von alten Sqlserver ... > darüberkopieren. ... Servicepack werden diverse DLL's installiert und so weiter. ...
(microsoft.public.de.sqlserver) - Re: Damn you, FEDEX! or Nikon D40 lost in Springfield, MO blackhole.
... the 2 mp Mavica he had been using with a Nikon D40. ... After shopping around, he got me to order one for him. ... The shipper had it insured, but from what I have read it could take weeks to sort this crap out. ... You may get your insurance from FedEx and a couple weeks later they find it and deliver it. ...
(alt.photography) - Re: Relationship Question
... should uncheck cascade update/deletes). ... master table) the primary table will contain unique values. ... If you have checked cascased update and cascade delete, ... delete/add whatever you want. ...
(comp.databases.ms-access) - Re: Cascade Delete Not Working Correctly?
... In order to do this you will need to enable Cascade Update as well as ... > I have a master table that is updated. ... > child records that are referenced by a foreign key with ... > DELETE/INSERT the child. ...
(microsoft.public.sqlserver.server) - Re: setting up a one to many link
... "Master List" something like tblCustomers or tblClients would be much ... there may be Transactions that have no matching Master ... to be deleted before establishing an Integrity and Cascade link. ...
(microsoft.public.access.forms) |
|
