4 ms·
Sure, it's where you write the high-level orchestration code for things that haven't been made sufficiently repeatable yet. :) Personally I tend to use it for
by tbrownaw 5y ago
Sure, it's where you write the high-level orchestration code for things that haven't been made sufficiently repeatable yet. :)
Personally I tend to use it for light one-off database metaprogramming. Get a lit of objects that need to be maintenanced, generate the appropriate commands with a column of identical formulas, and then paste that back into the sql utility. (For more complex or long-lived things I'll use a more traditional language of course.)
(Why yes, I am going to pretend I didn't accidentally a word.)
- PaulHoule 5y agoI've seen other people do that. I think it's better to use a language like Python, but I have seen people do SQL scripts and many other kinds of code gen with Excel.