|
|
|
|
|
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. |
|