SSMS Results

  • Comments posted to this topic are about the item SSMS Results

  • Too easy 😀

    Have a nice Easter weekend, and don't eat too much chocolate!

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Koen Verbeeck (4/18/2014)


    Too easy 😀

    Have a nice Easter weekend, and don't eat too much chocolate!

    +1000 :hehe:

  • When results come out in text, you can search for a string (ctrl+f), instead, in grid mode you can not search in the results.

  • twin.devil (4/18/2014)


    Koen Verbeeck (4/18/2014)


    Too easy 😀

    Have a nice Easter weekend, and don't eat too much chocolate!

    +1000 :hehe:

    hey,this is not done. I got only +1 😛

    --rhythmk
    ------------------------------------------------------------------
    To post your question use below link

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
    🙂

  • Carlo Romagnano (4/18/2014)


    When results come out in text, you can search for a string (ctrl+f), instead, in grid mode you can not search in the results.

    You can copy paste the grid easily to Excel though.

    And with Text mode it's not easy to see how many rows were returned.

    Another advantage of text is that is usually returns results much faster than the grid.

    And it's better to test dynamic SQL 🙂

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Koen Verbeeck (4/18/2014)


    Too easy 😀

    Have a nice Easter weekend, and don't eat too much chocolate!

    awww... Okay I will stop now. (...just one last piece...)

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • In SSMS 2008 r2, results could be copied only in grid mode or if the amount of the text is less than 2MB. If text is more than 2MB you should save results in a file.rpt

  • Carlo Romagnano (4/18/2014)


    In SSMS 2008 r2, results could be copied only in grid mode or if the amount of the text is less than 2MB. If text is more than 2MB you should save results in a file.rpt

    This QotD has become quite the "fun facts" collection about SSMS query results 😀

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Show hide query results pane shortcut is changed in SQL Server 2012 version.

    If the settings are imported from SQL Server 2008 settings, then it remain same CTRL +R. Otherwise CTRL+SHIFT+ALT+R will show hide the query result pane. (Show and hide the query result pane, not only to show)

    But when I look into the reference link, it says

    Show or hide the query results pane -> CTRL+R

    Show the query results pane -> CTRL+SHIFT+ALT+R

    What it means?

    -----------------
    Gobikannan

  • Gobikannan (4/18/2014)


    ...If the settings are imported from SQL Server 2018 settings...

    Well, that's what you get for time-travelling. 😛

  • Thanks for the easy one to end on a Friday Steve.



    Everything is awesome!

  • --------------

    That was easy!

    (1 row(s) affected)

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • I was hoping as it was easter this would be worth 7 points 🙂

    ---------------------------------------------------------------------

  • Koen Verbeeck (4/18/2014)


    Too easy 😀

    Have a nice Easter weekend, and don't eat too much chocolate!

    + a few T bills

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 15 posts - 1 through 15 (of 24 total)

You must be logged in to reply to this topic. Login to reply