From: MaMo on 9 Feb 2010 08:49
In a stored procedure i want to delete data from multiple tables.
Now i am doing this in my stored procedure:
DELETE FROM table1
DELETE FROM table2
DELETE FROM table3
DELETE FROM table4
.... and so on
Is it possible to do this in a more elegenat manner like holding the table
names in some kind of array or variable and use a cursor or something to do
Any help would be very appreciated!!!