May 6, 2005 at 10:21 am
You actually don't need to change to tab delimited to paste into Excel. You can do it from the standard Grid. Just click on the column name to select it. You can then hold down shift and select multiple (or all) columns. Then hit CTRL-C to copy. Works like a charm.
May 6, 2005 at 10:24 am
Thanks Brian. One benefit I like of switching to tab is that I can get the column headers too, where they are absent in grid mode.
May 6, 2005 at 10:31 am
Yeah, that is pretty useful. I've been wanting the headers too. Thanks, chewrock!
May 9, 2005 at 12:44 pm
For context sensitive help from BOL, you can highlight the SQL keyword(s) and type "SHIFT+F1"
May 9, 2005 at 11:17 pm
An obvious (I feel) one not listed that made me very happy when I learned it, is that you can select some of the code and press F5 to execute only that code.
Previously I was manually commenting out the bits I didn't want or cutting'n'pasting. Ah, my olde newbie days!
Steve (not Jones)
May 10, 2005 at 8:39 am
Actually either F5 or "Ctrl+E" or "ALT+X" will execute code.
I prefer "ALT+X" as the keys are close to my fingers.
May 11, 2006 at 1:09 pm
Can you post the script you use? I'd love to use it, too!
May 11, 2006 at 1:14 pm
do you know of anyway to associate the "Script Object to Clipboard as..." to a hotkey in Tools/Customize keyboard settings?
May 11, 2006 at 1:17 pm
BTW, in 2005's SQL Server Management Studio, when you do a SELECT, and copy from the grid, the headers now go with it to the clipboard!
YEA!
May 15, 2006 at 11:32 am
In SQL QA, there is a Scripting options... dialog shortcut to Tools>>Options>>Script tab. This is right under the Script Object to... options. It helps setting some added time saving options.
My next question would be; does any one know where this went in Sql Server Management Studio? Knock, knock.
{Francisco}
Viewing 10 posts - 46 through 54 (of 54 total)
You must be logged in to reply to this topic. Login to reply