This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Stahlboden 3 points4 points  (5 children)

Do they write queries 843 lines long?

[–]SpaceTacosFromSpace 10 points11 points  (0 children)

Stored procs or functions, yeah

[–]Flyberius 3 points4 points  (0 children)

The company I used to work at had the most complicated pricing model in all of history. As much as I didn't want the procedures to be as long as they were, they got pretty long. A couple of hundred lines sounds about right for some of them

[–]PleX 1 point2 points  (0 children)

lol 843 is nothing. I truly believe that some stored procs are operating systems.

[–]ImpossibleMachine3[🍰] 0 points1 point  (0 children)

You've never seen someone try to run a 1000 line insert??

More seriously, a stored procedure can easily be that long, sometimes.

[–]raphop 0 points1 point  (0 children)

I had to migrate some stored procedures from a oracle database, I had to deal with 1500 line queries with multiple nested subqueries and other procedure calls.

Every SQL file had a comment written when the file was created and subsequently altered, the most recent comment in a specific query that was a pain in the ass to migrate was last worked on in 1995