Click here to Skip to main content
14,774,347 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.
 
GeneralRe: Controversial: SQL Pin
raddevus1-Dec-20 18:41
mvaraddevus1-Dec-20 18:41 
GeneralRe: Controversial: SQL Pin
Choroid1-Dec-20 7:41
MemberChoroid1-Dec-20 7:41 
GeneralRe: Controversial: SQL Pin
raddevus1-Dec-20 10:01
mvaraddevus1-Dec-20 10:01 
GeneralRe: Controversial: SQL Pin
Choroid21-Dec-20 6:41
MemberChoroid21-Dec-20 6:41 
GeneralRe: Controversial: SQL Pin
Member 109454291-Dec-20 8:39
MemberMember 109454291-Dec-20 8:39 
GeneralRe: Controversial: SQL Pin
raddevus1-Dec-20 10:02
mvaraddevus1-Dec-20 10:02 
GeneralRe: Controversial: SQL Pin
Member 109454291-Dec-20 10:30
MemberMember 109454291-Dec-20 10:30 
GeneralRe: Controversial: SQL Pin
Mark Starr1-Dec-20 9:57
professionalMark Starr1-Dec-20 9:57 
So, it depends on which interface you're using.

If you're using Management Studio you can save frequently-used queries in 2 places (I've used both over the years):

1) Create a 'Project' (File / New / Project / SQL Server Scripts) and save .SQL files into that project. Kinda clunky for organization, but workable. I used this method as a default, and used file naming for file sorting and commented keywords for searches. Sometimes you have to open the project file and manually rearrange the file references.

2) use the Code Snippets Manager (Tools / Code Snippet Manager) You can create your own Groups and add scripts to existing or new Groups. pretty handy, a little clunky, but it works. I used this area for some very-frequently-used utility scripts.

If this info is coming to you late, well - I read your thread early this morning, but didn't get to my computer till now. Take it for what its worth.

Cheers,
Time is the differentiation of eternity devised by man to measure the passage of human events.
- Manly P. Hall

Mark
Just another cog in the wheel

GeneralRe: Controversial: SQL Pin
Mark Starr1-Dec-20 9:59
professionalMark Starr1-Dec-20 9:59 
GeneralRe: Controversial: SQL Pin
raddevus1-Dec-20 10:04
mvaraddevus1-Dec-20 10:04 
GeneralRe: Controversial: SQL Pin
Mark Starr1-Dec-20 10:17
professionalMark Starr1-Dec-20 10:17 
GeneralThrow away your iPhone! Pin
OriginalGriff30-Nov-20 7:41
mveOriginalGriff30-Nov-20 7:41 
GeneralRe: Throw away your iPhone! Pin
raddevus30-Nov-20 9:09
mvaraddevus30-Nov-20 9:09 
GeneralRe: Throw away your iPhone! Pin
OriginalGriff30-Nov-20 9:57
mveOriginalGriff30-Nov-20 9:57 
GeneralRe: Throw away your iPhone! Pin
raddevus30-Nov-20 11:55
mvaraddevus30-Nov-20 11:55 
GeneralRe: Throw away your iPhone! Pin
OriginalGriff30-Nov-20 11:59
mveOriginalGriff30-Nov-20 11:59 
GeneralRe: Throw away your iPhone! Pin
raddevus30-Nov-20 12:05
mvaraddevus30-Nov-20 12:05 
GeneralRe: Throw away your iPhone! Pin
Dan Neely30-Nov-20 9:14
MemberDan Neely30-Nov-20 9:14 
GeneralThought of the Day Pin
OriginalGriff30-Nov-20 5:37
mveOriginalGriff30-Nov-20 5:37 
GeneralRe: Thought of the Day Pin
W Balboos, GHB30-Nov-20 5:41
mveW Balboos, GHB30-Nov-20 5:41 
GeneralRe: Thought of the Day Pin
Marc Clifton30-Nov-20 5:49
mvaMarc Clifton30-Nov-20 5:49 
GeneralThe Terror of Windows 10 Pin
Gerry Schmitz30-Nov-20 4:28
mveGerry Schmitz30-Nov-20 4:28 
GeneralRe: The Terror of Windows 10 Pin
W Balboos, GHB30-Nov-20 5:38
mveW Balboos, GHB30-Nov-20 5:38 
GeneralRe: The Terror of Windows 10 Pin
Rick York30-Nov-20 5:58
mveRick York30-Nov-20 5:58 
GeneralRe: The Terror of Windows 10 Pin
Peter Adam1-Dec-20 1:22
professionalPeter Adam1-Dec-20 1:22 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.