2 ms·
In response to the default Darcula theme on Windows, specifically the gray for the comments vs. the gray background: https://contrastrebellion.com/ https://cont
by password4321 2y ago
In response to the default Darcula theme on Windows, specifically the gray for the comments vs. the gray background: https://contrastrebellion.com/ https://contrastrebellion.com/
In SQL Management Studio it is easy to work with stored procedures. The server starts the tree on the left, and all databases on the server are the next level down (not a separate connection for each database). Then beneath that (2 levels) each stored procedure is listed and can be opened easily for modification in the editor.
I will return to this app if I need to munge/import data in the future but it's not worth the effort for my normal work with stored procedures as best I can tell from a quick start. It's not immediately clear how to pull a stored procedure up in the editor without running a query manually to grab its definition.
- password4321 2y agoWell I had an opportunity to munge some data, but the .CSV file had spaces in its name so the generated SQL failed with an error because it started by creating a DuckDB view named the same as the file, without escaping the spaces. I tried putting []'s (brackets) around the name to escape the spaces but apparently that's not how DuckDB works. Also, I'm used to using F5 to run the queries but that didn't work either.