Nobody likes Open Query File operations. However, we’re all more or less forced to live with them and, more importantly, maintain them. Here’s how to replace them with SQL cursors.
By Rafael Victória-Pereira
The prospect of “killing” those error-prone, problem-magnet Open Query File operations sounds nice, doesn’t it? Well, SQL cursors are the way to go. However, before I get to that part, there are a few things about cursors that you need to take note of.