Subject Stored procedure - custom SQL
Author Robert martin

I am writing a stored procedure to replace some existing app code.

As part of the procedure I get a list of tables that meet certain
criterion. I then want to run an update SQL on each of these tables. In
my code I built the SQL on the fly as shown below.

i.e. 'UPDATE ' + fTableName + ' SET .........

Can I do this in a SP (I suspect not)? Are there any other options, I
cant hard code the list of tables as they will change.?


Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496

Wild Software Ltd