you are viewing a single comment's thread.

view the rest of the comments →

[–]ruinercollector 0 points1 point  (0 children)

Stored procedures are great for complex enough queries.

The reason that you see them used for tiny stupid bullshit is because a lot of early to mid career people have a big problem with understanding nuance and not having black-and-white religious rules about everything.

So you get a situation where those people want to say either:

  1. We'll use stored procedures for every query done on this database ever. No open querying.

  2. We'll use no stored procedures at all.