I have SQL Server 2005. Holding shift while pressing the spacebar selects an entire row. I can then use my arrow keys to move about the cells and it selects the entire cell I'm on. I am looking for a way to modify the cell without clicking the mouse. Is there a way to go from entire cell selected to cursor in the cell by using the keyboard? Thanks
View 1 Replieshello friends..
i am a new user to sql,
i was wondering if anyone here will help me to get all the keyboard shortcuts while working on sql...
thankyou
Is there a keyboard shortcut to add a <NULL> value into a field on my SQL Server 2000 database table, using SQL Server Enterprise Manager
View 1 Replies View Related
I have been using SSRS2k5 now since early CTP, and one thing that bothers me is the lack of keyboard shortcuts and windows standards.
For example: If I am in the data screen, and want to enter a SQL Query, I cannot use the tab key. So I copy it to SQL Management Studio, but I cant use CTRL-A to select all.
If I am in the layout tab, and want to bold a field, I hit CTRL-B, but that pulls up the breakpoint entry dialog.
If I have a table on a report, and want to add click-thru navigation, I have to:
Right click on cell 1
Click on properties
Select Navigation
Click on Jump to Report
Select the report from the list
Click on parameters
Select parameter 1
Now, if I want a field as the parameter, i can just select from the drop down, but most of the time I am passing parameters from the 1st report to the 2nd report. Then i have to:
Click on the Expression button
Either type the parameter name, or click on it from the list.
Press OK
Repeat number 8 for the number of parameters.
Hit OK.
Hit OK.
REPEAT FOR ALL CELLS
Now, here is the issue... If you have a 20 column table, and have similar click thru functionality, you have to repeat this process for each cell. You cannot multi select. THAT would be a huge timesaver. I would rather set all 20 cells the same, and tweak 1 or 2, rather than kill my wrist mousing thru the above process 20 times. (It hurts, trust me )
These seem like little things, until you are working on 50 reports in a short time frame.
Anyone else find this bothersome?
Is there any improvement on the GUI in the next release?
Thanks!
BobP
Anyone know if there is one and if so what it is? I know I can type directly into a text box in a table, but what if I want to edit the contents? Equivalent of F2 in Excel...
Thanks
large tabular cubes (SSAS 2012 SP2), with lots of calculations, the keyboard seems to be stuck, one cannot type or make any modifications to any measures, even after closing a project.
The only workaround is to completely restart the machine. Using Visual Studio 2010 Shell.
Are there any possibly corruptions or calc limitations that one should be aware of?
Notable that this never happens with any small cubes, but just with the largest cube that we have, that has probably tens of calcs.
I know my problem is not directly associated w/ SSIS, so please forgive the post here. I figured this would be the "most" appropriate place to post this challenge.
We're attempting to edit a 2000 DTS package in Design mode from within the 2005 SQL Management Studio. To do this we downloaded/installed the following packages from the MS download site:
Microsoft SQL Server 2000 DTS Designer Components
Microsoft SQL Server 2005 Backward Compatibility Components
We're able to open the package in design mode from the Management Studio (Server > Management > Legacy > Data Transformation Services > DTS Package Name). But, when the DTS designer is open, the backspace and arrow keys won't respond in the Management Studio. They begin responding when we close the DTS designer. There are no error messages when we close the DTS designer.
Does anyone know of a fix or a workaround? Any help would be greatly appreciated.
Thanks, Mike