how do humans debug a 180 lines stored procedure :/ ?

they dont write stored procedures lol

First debug only the four lines.
Secondly debug the rest of the goddamn 174 lines.
Those last 2 lines are never buggy.;)

"how do humans debug a 180 lines stored procedure :/ ? "

The standard industry practice way is to do it with a lot of profanity followed by a silent prayer for an office fire.

180 lines... that's so adorable! In an old job I had to edit one that was over 1000 lines.

You haven't seen anything. I hate to brag about this, but unfortunately I've seen some really long procedures. :(

I don't around line 90 cuthlu snores and your head explodes

@ridecar2 I forgot what that procudere does before reaching line 100 :/

it is hard to debug because you can't see where did the error happen.

I had to copy a few lines at a time and execute them, check the result and copy into the next chunk of lines.

I feel your pain, that is why I am so glad that I work with Entity Framework in my latest project. No SQL in sight...:-)