![]() If you aren't sharing and preserving your patterns why go to the trouble of formatting? As long as the syntax is correct and the execution order is correct why format at all if it isn't going to be saved? Now if you are saving your scripts then why would your office team members be writing and rewriting code that can be easily stored on the desktop or on a file server or even in the database itself via stored proc functions triggeres synonyms view creation scripts index scripts schema scripts table creation scripts and even just saving a current query tab including connection information as a *.sql file? If your queries and those of your office folk are so ad hoc that you aren't saving off your scripts into files and reusing code then really don't have much of a use case for a formatter at all. ![]() So it sounds like your use case isn't that of a SQL developer (we tend towards creating long lasting reusable code and leave ad hoc queries to testing out patterns and results from same) but more of a business analyst with back-end access and experience. Perhaps I'll ask for good tools regardless of price once I get my first salary, but until then, my options are limited. It sucks, but that's the current state of my bank account. What they've built includes other tools which I don't need at the moment, so I would be paying them for tools I don't use.Īnd, as I've stressed out enough before, I currently don't have the money to invest in any paid tool, regardless of how good or cheap it is, which means I can't support the engineers which have built those tools nor get myself something adequate and that is kept up to date. I test my queries while building them pretty often.Īnd besides, I just need a formatter. Never have I said that they should work for free, but simply that the other options available blow their offer out of the water, if not for the fact that their plugin runs within SSMS.įurthermore, the alternative you gave me would slow me down significantly, because it's more than just a few Ctrl key shortcuts, and it's time which adds up quickly when constantly formatting even 10 times in a minute. ![]() I appreciate their work, but I am saying that it seems excessive to pay $200 a year, or roughly $16 a month (which isn't exactly cheap for a salary where I live), when VSC and VS format all sorts of text for free. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |