Subject Updating a stored procedure
Author Gaurav Sood
Hi All,

I have a set of cascade delete procedures which delete all records
associated with clients if you delete the profile of a client from a
People table within the database. The cascade delete will totally
remove all details of all clients and their relevant transcripts from
the database if you 'delete from People'. However, the generators that
are used for the samples, people and transcriptions are not reset to
0; they are of differing values of say (3,6 and 8). I want to update
the cascade delete to set the generators to 0. How would I do this to
a populated database ?
(without creating a new database with the new strored procedure and
then refilling the data)?

Do the commands "Set Generator generator_name to value;' not work
within a stored procedure?




B. Engineering, B. IT
A.N.U (2004)

M: +61 401 409 620
H: +61 3 9376 8580

"In life, always do right. This will gratify some people and astonish the rest."

— Mark Twain