4 ms·
That makes sense actually. But stored procedures could do that too?
by gigatexal 8y ago
That makes sense actually. But stored procedures could do that too?
- radiowave 8y agoYes. I tend to treat procedural code as a last resort, because pure declarative SQL is so much easier to troubleshoot.
- gigatexal 8y agoI guess I use stored procedures differently. I rely on SQL queries not for loops if I can help it. Sometimes it can’t be avoided if you’re doing updates in chunks for example.