Hi All
i have a common field say email in 5 tables.
i want to delete a single record which should be deleted from all the table from which the email is related.
can anybody suggest me for the same.
Thanks
Printable View
Hi All
i have a common field say email in 5 tables.
i want to delete a single record which should be deleted from all the table from which the email is related.
can anybody suggest me for the same.
Thanks
You should run 5 separate Delete statements, all within a transaction (so either they will all be deleted, or none of them will be).
Exactly how you do this depends on a few factors, such as what database system you are using, and where you want to run this from.
I m using sql server2000 as an backend. and ASP front end.
I want to make a function and want to call it in asp page.
in this function i need to write delete command .
Quote:
Originally Posted by si_the_geek