I have a denormalized database, where there are done frequent changes from different users and I don't want users to change tables directly. What do you suggest to implement for better? I am considering to use view or stored procedure, or maybe table-valued function. What do you suggest?
Answer by Magnus Ahlkvist ·
A function can not be updateable. A view can be updateable, but not if it's a complex view (eg containing joins between different tables). You can create an insteadof-trigger on a view, but if I were you, I'd implement stored procedures to make changes.