Hello,
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?
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.
Stored procedures are better for this type of thing. They can do some seriously complex things, especially when in comes to inserting or updating a "record", which may actually live across multiple tables.
17 People are following this question.
