Ad hoc queries vs stored procedures vs Dynamic SQL [closed]
Stored Procedures Pro: Good for short, simple queries (aka OLTP–i.e. add, update, delete, view records) Pro: Keeps database logic separate from business logic Pro: Easy to troubleshoot Pro: Easy to maintain Pro: Less bits transferred over network (i.e. only the proc name and params) Pro: Compiled in database Pro: Better security (users don’t need direct … Read more