4 ms·
Isn't That how your supposed to do it using Sprocs is more time consuming but it does have several advantages from security and performance.
by spacecowboy_lon 11y ago
Isn't That how your supposed to do it using Sprocs is more time consuming but it does have several advantages from security and performance.
- gdulli 11y agoThere's no way you're "supposed to" do it. There are tradeoffs and you pick the approach you like most given those tradeoffs.
- spacecowboy_lon 11y agoNot sure id agree 100% with you for standard LOB CRUD applications the use of Sprocs is best practice. Obviously if your just writing a tool that will be used 2 or 3 times that - you can make trade offs - but you should never use $sql = "SELECT * FROM tblBobbins"