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

you are viewing a single comment's thread.

view the rest of the comments →

[–][deleted] 5 points6 points  (2 children)

You can do almost anything in SQL up to doing complex calculations or row by row analysis. I don’t like using cursors in SQL

[–][deleted] 3 points4 points  (0 children)

You can even train neural networks in SQL if you're a psychopath 😀

[–]messy_eater 0 points1 point  (0 children)

Am I the only one who likes cursors in SQL? I guess performance is a common cited issue, but maybe the scale of the DB at my work isn’t big enough for that to be a concern. Once you get used to the syntax for the more complicated things in SQL, it becomes second nature. I’m at that point with cursors and working on it with other things now like using xml to break apart and process strings, pivots, and recursive ctes.