3/23/2023 0 Comments Razorsql shortcuts![]() DynamoDB: Enhanced logic to determine when to execute a query request and when to execute a scanrequest when query or scan is not indicated in select queryDynamoDB: added support for in clauses in SQL statementsDynamoDB: Import Tool: Added a checkbox for skipping columns / attributes in generatedinserts when the value is null / emptyAdded ability to set connection properties when using the MS SQL Server JDBC driver from MicrosoftDynamoDB: support beginning comments in queriesDynamoDB: A non-descriptive error is thrown when referencing an attribute in an SQLstatement that does not exist in the tableIf SQL Server jtds connection fails for SSL reasons, and MS SQL Server driver is installed,try connecting with the SQL Server driverChanged the formatting of the query error text to handle line wrapping betterFaster scroll speed on Explain Plan windowIf result columns are moved and put back in the same place - results editor throws errorpreventing changes due to columns being re-arrangedPostgreSQL: editing views taking a long time in certain situationsQuery Builder: add table button window appearing behind the query builder on MacQuery results edit table button not always appearing for supported queries when the querieshave comments in them DynamoDB: Added ability to force a query or scan operation using the select_query or select_scansyntax instead of just selectselect_query * from employee where id = 1DynamoDB: Added ability to specify an index to use for a query operation using a query hintselect_query /*index_name*/ * from table_name where. Added support for the Cassandra databaseAdded an Edit -> Delete Lines Containing optionSalesforce: Added the ability to connect to a Salesforce sandbox environmentFunction Navigator / Function Selector: Now shows both procedures and functionsin Oracle PL/SQL packagesQuery Scheduler: Added option to set start timein seconds from current timeQuery Scheduler: Added option to set the title of the query schedulerwindowQuery Scheduler: Added option to determine whether to overwriteor append to the output file if it already existsQuery Scheduler: Added option to load query text from a fileQuery Scheduler: Added option to load query text from the SQL favorites listQuery Scheduler: Added file name, interval, executions, and query tostatus field of query scheduler windowContinue should be the default button on the Add Connection Wizard screenAdded additional error notifications for the Export toolIf a maximum rows value is set in the preferences, that valuewill get set on the JDBC driver's statement object for each querySalesforce: Using TableName.ColumnName syntax in queries returns nullvaluesSalesforce: Relationship queries using join tables via dot notation columns(example: ) returning nullvalues for columns from the joined tablesSalesforce queries not always returning rows above initial salesforcerequest limitsMac 64-bit: Various focus issues where windows / dialogs are not gettingfocus when appearing When you make this change, it applies to all current query windows, and all other query windows that you open until you change it back.Stable version. ![]() You could also, of course, just use that drop-down to set the zoom level too: Note that as you do that, the percentage of zoom is also displayed in the lower left-hand side of the query window. There are several options to allow you to zoom in, without needing to change the settings.įirst, like many Windows programs, you can hold down the Control key and use the mouse scroll bar to increase or decrease the font size. The pain with this is that you then need to set them back later. What I often see someone do then, is to go into Tools and Options and start to change the font and color settings. ![]() When working with SQL Server Management Studio, sometimes you need to show someone else what you're working on, and the fonts that you're using are just too small for someone looking over your shoulder or looking at a screen that you've shared with them.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |