Controversial: SQL
-
There is no good way to store good SQL queries for future use. Just, no good way. :rolleyes:
I keep a text file of 'em: "GoodSQLQueries.txt" it's called. It's easy to copy'n'paste 'em when I need 'em. Or just use an SP. What's the problem?
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt AntiTwitter: @DalekDave is now a follower!
-
There is no good way to store good SQL queries for future use. Just, no good way. :rolleyes:
I'm not sure I follow, would you mind expanding?
Wrong is evil and must be defeated. - Jeff Ello Never stop dreaming - Freddie Kruger
-
I keep a text file of 'em: "GoodSQLQueries.txt" it's called. It's easy to copy'n'paste 'em when I need 'em. Or just use an SP. What's the problem?
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt AntiTwitter: @DalekDave is now a follower!
Well, I have something like that too, but it's difficult to find the right one amidst all of the other chaff. I wish there was a way to categorize them or something like that. And don't offer me the idea of making sections in my text file, cuz i'm lazy (of course -- I'm a dev). :-D
-
I'm not sure I follow, would you mind expanding?
Wrong is evil and must be defeated. - Jeff Ello Never stop dreaming - Freddie Kruger
There's no great way to : 1) store and categorize good sql 2) also would like a way to insert table names and field names so you could select some things and then just fire off the SQL. 3) need a place for notes about what the sql actually does. I tend to forget sql very fast -- sql is boring and declarative and I always have to look at it too much to remember what it does. Sometimes I just want to find an old query that does that thing you know? :)
-
Well, I have something like that too, but it's difficult to find the right one amidst all of the other chaff. I wish there was a way to categorize them or something like that. And don't offer me the idea of making sections in my text file, cuz i'm lazy (of course -- I'm a dev). :-D
:-O I have sections in my text file ... because I'm lazy ... :laugh:
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt AntiTwitter: @DalekDave is now a follower!
-
:-O I have sections in my text file ... because I'm lazy ... :laugh:
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt AntiTwitter: @DalekDave is now a follower!
OriginalGriff wrote:
I have sections in my text file ... because I'm lazy ...
:thumbsup: That made me laugh too. I would like: 1) way to pick tables and fields (returned in query) 2) have notes that remind me what the query does 3) have a good way to find them again -- this wouldn't be easy to do I end up saving large SQL text files all over the place and then later searching through them and it takes just about as long to find them as it does to just think it all out again. I'm just wishing over here. :-D It would be very difficult to really create a good organizer. I guess I'm even lazier than I thought. (which I didn't think was possible)
-
There is no good way to store good SQL queries for future use. Just, no good way. :rolleyes:
My current project has a folder in google drive (coworkers choice, I'd've added a folder in our git repo) to store all the supposedly 1 off queries (if they said they wanted it repeatedly we'd have a report/import page) we've ran for the customer so they're available for the next time they ask.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason? Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful? --Zachris Topelius Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies. -- Sarah Hoyt
-
There's no great way to : 1) store and categorize good sql 2) also would like a way to insert table names and field names so you could select some things and then just fire off the SQL. 3) need a place for notes about what the sql actually does. I tend to forget sql very fast -- sql is boring and declarative and I always have to look at it too much to remember what it does. Sometimes I just want to find an old query that does that thing you know? :)
- I simply use the file system. Every file gets a [declarative name].sql, so you can doubleclick and it will start SSMS or whatever program is associated. The master folder is also added to TortoiseHg for versioning 2) Then you need to use dynamic SQL, which is a whole can of worms by itself, and also a possible source of so called SQL-injection 3) I use a fancy invention called Comments for that. Just add them to forementioned Files In Oracle you can also add comments directly to the tables and columns themselves, but in SQL Server you only have Extended Properties, which aren't nearly the same thing
Wrong is evil and must be defeated. - Jeff Ello Never stop dreaming - Freddie Kruger
-
My current project has a folder in google drive (coworkers choice, I'd've added a folder in our git repo) to store all the supposedly 1 off queries (if they said they wanted it repeatedly we'd have a report/import page) we've ran for the customer so they're available for the next time they ask.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason? Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful? --Zachris Topelius Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies. -- Sarah Hoyt
Possibly you need something like [Zim - a desktop wiki](https://zim-wiki.org/)
Keep Calm and Carry On
-
There is no good way to store good SQL queries for future use. Just, no good way. :rolleyes:
The solution to your problem with storage, retrieval and categorizations is obvious: Put them into a database.
"The difference between genius and stupidity is that genius has its limits." - Albert Einstein
"If you are searching for perfection in others, then you seek disappointment. If you seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010
-
There is no good way to store good SQL queries for future use. Just, no good way. :rolleyes:
not sure if this is even relevant or helpful: Transact-SQL Code Snippets - SQL Server Management Studio (SSMS) | Microsoft Docs[^] I save my sql to an organized sql folder locally, of which you could add to source control or cloud storage if you wanted to. it's not the greatest method, but I have been doing it this way for years and will probably not change. :-D
-
OriginalGriff wrote:
I have sections in my text file ... because I'm lazy ...
:thumbsup: That made me laugh too. I would like: 1) way to pick tables and fields (returned in query) 2) have notes that remind me what the query does 3) have a good way to find them again -- this wouldn't be easy to do I end up saving large SQL text files all over the place and then later searching through them and it takes just about as long to find them as it does to just think it all out again. I'm just wishing over here. :-D It would be very difficult to really create a good organizer. I guess I'm even lazier than I thought. (which I didn't think was possible)
-
The solution to your problem with storage, retrieval and categorizations is obvious: Put them into a database.
"The difference between genius and stupidity is that genius has its limits." - Albert Einstein
"If you are searching for perfection in others, then you seek disappointment. If you seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010
-
not sure if this is even relevant or helpful: Transact-SQL Code Snippets - SQL Server Management Studio (SSMS) | Microsoft Docs[^] I save my sql to an organized sql folder locally, of which you could add to source control or cloud storage if you wanted to. it's not the greatest method, but I have been doing it this way for years and will probably not change. :-D
-
Visual has/had a code snippets kind of thing. Maybe that could be adapted.
"They have a consciousness, they have a life, they have a soul! Damn you! Let the rabbits wear glasses! Save our brothers! Can I get an amen?"
You can also set it up in the VS toolbox as boilerplate code to drag and drop into an app - I use it for boilerplate SQL access to be "tuned" for a specific purpose.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt AntiTwitter: @DalekDave is now a follower!
-
There's no great way to : 1) store and categorize good sql 2) also would like a way to insert table names and field names so you could select some things and then just fire off the SQL. 3) need a place for notes about what the sql actually does. I tend to forget sql very fast -- sql is boring and declarative and I always have to look at it too much to remember what it does. Sometimes I just want to find an old query that does that thing you know? :)
We have a database for saving queries like that as stored procs. Everybody has their own schema, and can see each other's procs. Most of them are specific to the table/view being queried.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013 -
My current project has a folder in google drive (coworkers choice, I'd've added a folder in our git repo) to store all the supposedly 1 off queries (if they said they wanted it repeatedly we'd have a report/import page) we've ran for the customer so they're available for the next time they ask.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason? Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful? --Zachris Topelius Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies. -- Sarah Hoyt
Yeah, I did something similar by creating a document on Google Drive. Just wish there was a better way to manage them with comments etc. By "better way", I mean i could just think of a query I've done in the past and it would appear on my screen. :laugh:
-
MSSQL snippets works perfectly for me except you need to rabbit through the category folders to find the exact one you need :-O. Tis a bitch when you can't remember the category/folder it lives in.
Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP
-
- I simply use the file system. Every file gets a [declarative name].sql, so you can doubleclick and it will start SSMS or whatever program is associated. The master folder is also added to TortoiseHg for versioning 2) Then you need to use dynamic SQL, which is a whole can of worms by itself, and also a possible source of so called SQL-injection 3) I use a fancy invention called Comments for that. Just add them to forementioned Files In Oracle you can also add comments directly to the tables and columns themselves, but in SQL Server you only have Extended Properties, which aren't nearly the same thing
Wrong is evil and must be defeated. - Jeff Ello Never stop dreaming - Freddie Kruger
Jörgen Andersson wrote:
- Then you need to use dynamic SQL, which is a whole can of worms by itself, and also a possible source of so called SQL-injection
I'm just talking about a local resource that I would use to call up previous queries that I've had to do to examine or update data manually. All of our work is done view SPs -- there are no ad-hoc SQL that are allowed to run against our DBs.
