I don't believe there is a way within ArcGIS to do this. However, this is a good thing, as Vince noted, could be extremely dangerous. So if you want to do this, you will have to resort to programming. If you are doing this via programming, be ABSOLUTELY sure you know what you are doing.
My personal use in using stored procedures 99% of the time is only in a read only context to extract data to make outside joins upon. The other 1% is strictly for updating non geometric attributes.
Have you looked at defining a "View".