4 ms·
If anyone is using dynamic SQL in their application built using functions or stored procedures, I seriously doubt their competency. Dynamic SQL exists just bec
by timacles 3y ago
If anyone is using dynamic SQL in their application built using functions or stored procedures, I seriously doubt their competency.
Dynamic SQL exists just because it can. It had absolutely no use case outside of I want to slap together some SQL statements real quick and don't feel like using anything except the DB.
- _a_a_a_ 3y agoI'm using dynamic SQL right now because generating almost a thousand almost-identical statements by hand would be stupid. It is necessary sometimes.