May 16, 2014 at 8:42 am
batgirl (5/16/2014)
As is often the case, I am now thoroughly confused.I am pretty sure that I need a vacation, or at least a long weekend.
I assumed that "NOT" was typo and was meant to be "NOW". In that case, Control + D was the correct answer for SQL 2012.
I also assumed "not" should have been "now". Oops :hehe:
Be still, and know that I am God - Psalm 46:10
May 16, 2014 at 9:12 am
Arrggh, I ticked the wrong box, and apparently got fooled by the documentation. I use this all the time, so I'm guessing I was moving to fast, thinking CTRL+D, but reading the docs and using Shift.
Points will be awarded back shortly.
May 16, 2014 at 1:58 pm
Igor Micev (5/16/2014)
CTRL+T - for textCTRL+D - for grid
in my ssms 2008r2, 2012 and 2014.
And in mine for 2008R2 and 2012.
Don't understand why all these people are claiming the answer is wrong. Maybe they just haven't noticed that the action for CTRL+D depends on context - if you currently have results to text it switches results to grid. If you already have results to grid, it does something different, namely nothing.
edit: Ah, I now see that earlier today the wrong answer was right (and there was a wrong word too). I should have read to the end of the discussion to date before commenting (and wouldn't have commented if I had seen Steve's post).
Tom
May 17, 2014 at 4:44 am
Steve Jones - SSC Editor (5/16/2014)
Arrggh, I ticked the wrong box, and apparently got fooled by the documentation. I use this all the time, so I'm guessing I was moving to fast, thinking CTRL+D, but reading the docs and using Shift.Points will be awarded back shortly.
:angry:
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
May 17, 2014 at 4:48 am
TomThomson (5/16/2014)edit: Ah, I now see that earlier today the wrong answer was right (and there was a wrong word too). I should have read to the end of the discussion to date before commenting (and wouldn't have commented if I had seen Steve's post).
Yeah, me too 🙁
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
May 17, 2014 at 5:41 am
paul.goldstraw (5/16/2014)
I had a similar problem with 2012 where using CTRL+R didn't toggle the results window. I followed the advice on this page. Perhaps you're affected in the same way?
Thanx for that link, it worked for me too, but I don`t recall that I ever changed the default behavior for keyboard shortcuts :w00t:
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
May 17, 2014 at 1:53 pm
Steve Jones - SSC Editor (5/16/2014)
Arrggh, I ticked the wrong box, and apparently got fooled by the documentation. I use this all the time, so I'm guessing I was moving to fast, thinking CTRL+D, but reading the docs and using Shift.Points will be awarded back shortly.
Just changing the order of the answers didn't give points back, now it says that the most answered was CTRL+Shift+D but obviously was CTRL+D :-D:-D
May 18, 2014 at 11:11 pm
Easy one, thanks Steve.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 19, 2014 at 2:09 am
Hany Helmy (5/17/2014)
paul.goldstraw (5/16/2014)
I had a similar problem with 2012 where using CTRL+R didn't toggle the results window. I followed the advice on this page. Perhaps you're affected in the same way?
Thanx for that link, it worked for me too, but I don`t recall that I ever changed the default behavior for keyboard shortcuts :w00t:
Nor did I, it happened for me on a fresh install of SQL 2012 the first time. I wonder if it's related to having versions of Visual Studio installed, causing the shell to get confused. Glad I could help though 😀
May 19, 2014 at 2:18 am
paul.goldstraw (5/19/2014)
Hany Helmy (5/17/2014)
paul.goldstraw (5/16/2014)
I had a similar problem with 2012 where using CTRL+R didn't toggle the results window. I followed the advice on this page. Perhaps you're affected in the same way?
Thanx for that link, it worked for me too, but I don`t recall that I ever changed the default behavior for keyboard shortcuts :w00t:
Nor did I, it happened for me on a fresh install of SQL 2012 the first time. I wonder if it's related to having versions of Visual Studio installed, causing the shell to get confused. Glad I could help though 😀
hmmm, maybe that`s the reason 🙂
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
May 21, 2014 at 6:08 am
Well, I haven't tried it in 2014 but CTRL+D works in 2008R2 so I went for it and got it right.
---------------
Mel. 😎
June 6, 2014 at 9:01 am
Worst. Question. Ever.
Now I know that you toggle results to text with a simple CTRL-T. I also know that CTRL-G is going to bring up a goto line number prompt.
So it leaves me with the remaining 2 options; of which I was fairly certain CTRL-SHIFT-D will bring up the dependency viewer. This leaves CTRL-D.
I opened up SSMS, toggled results to text, ran the query. then hit the ol' CTRL-D...nothing happened. Results are still going to text. Hit CTRL-SHIFT-D, dependency viewer popped up.
What am I missing here? I am curious now as to how you can actually achieve this, because not one of the shortcuts listed on msdn, or this question accomplish the task.
June 11, 2014 at 1:50 am
Koen Verbeeck (5/16/2014)
Richard Warr (5/16/2014)
Easy one, thanks.You have the only working copy of SQL Server 2012 where CTRL+SHIFT+D actually does something?
+1
Not suggesting anything but I see a lot of these Point Gatherer answers.
June 11, 2014 at 1:53 am
Richard Warr (5/16/2014)
paul.goldstraw (5/16/2014)
Koen Verbeeck (5/16/2014)
Richard Warr (5/16/2014)
Easy one, thanks.You have the only working copy of SQL Server 2012 where CTRL+SHIFT+D actually does something?
Maybe he's running SQL Server 2012 QOTD Edition? 😉
No, I'd noticed that the thread didn't have any "Easy one" posts so thought I'd better put one in 🙂
+1
Good Answer. Ignore my other comment on "Easy One"
Viewing 14 posts - 31 through 43 (of 43 total)
You must be logged in to reply to this topic. Login to reply