Hacker News new | ask | show | jobs
by logn 4401 days ago
I am a professional programmer (although not a DBA), and have used excel to generate SQL scripts. You can often just put all the variable in cells and then use string concatenate to add in the parts of a SQL script that repeat. It works well and lets others easily maintain/modify it. These are mostly for throwaway scripts or one-off analysis tasks.