I am trying to write a stored procedure that will attempt an
Update ...
statement first. Then it should check for the number of records
affected by
the Update statement, and if the number of records affected are
zero, it
should issue an Insert... statement.

How do I find out the number of records affected by an action
query?


Thanks and Regards,

Anand S. Kashelkar
Mumbai




__________________________________
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/