Stored Procedures Vs. Views

Well, I’d use stored proc for encapsulation of code and control permissions better.

A view is not really encapsulation: it’s a macro that expands. If you start joining views pretty soon you’ll have some horrendous queries. Yes they can be JOINed but they shouldn’t..

Saying that, views are a tool that have their place (indexed views for example) like stored procs.

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)