Data Compare files created in previous versions of Toad are supported. New Data Compare projects you create are saved using this new XML format. The file extension (.dcp) remains the same. The Data Compare project file has a new XML format. This allows you to quickly see which windows have executing statements. The animated background processes icon has been enhanced to provide a clearer indication that a window is associated with a currently running process.įor each Query Builder or Editor document with an active background process, this animated icon displays in the window's tab. Select All in one tab and then select Enable all results view. To enable/disable this feature, go to Tools | Options | Database | Script Result. When multiple results are displayed in a single tab, select All results to display all result sets in a single grid, or use CRTL+Click to display only the selected sets.
When a query returns multiple results, you can now display all results in a single grid. Then browse to and select the file containing values.ĭisplay Multiple Results in a Single Grid In the SQL Editor, select Get values from file in the code completion list. Click the down arrow to display the loaded values or to deselect some values. In the Query Builder, use the Where Condition editor to select the file containing values.Īfter the file is uploaded, the values are automatically added to the Where clause. If you are using IN or NOT IN in a WHERE clause, you can now load multiple values from a. Populate Where Clause with Values from File To open Spotlight Developer from within Toad for SQL Server, click Tools | Monitor | Spotlight Developer. Spotlight Developer is a free tool which you can download from the Spotlight Essentials web site. Monitoring of your SQL Server instances and health check analysis has moved from Toad for SQL Server to Spotlight Developer.
0 kommentar(er)
