Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal

< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7

You are here: Edit SQL > Recall SQL Statements

Recall SQL Statements

SQL Recall saves individual statements that were executed in the Editor or Query Builder so you can reuse them. This can reduce the amount of time needed to write code or execute frequently used, single statement queries.

Note: SQL Recall only works with a single statement. If you execute more than one statement, none of the statements are added to SQL Recall.

To add a recalled statement

Select View | SQL Recall from the menu.
Double-click the statement or drag it to an open Editor window or the Query pane in the Query Builder.

Troubleshooting: If you are unable to paste the statement in the Editor or Query Builder, make sure that the correct database is active.

Tips:

To save a recalled statement as a Code Snippet, click in the SQL Recall toolbar.
To save a statement to use it in future sessions, right-click the statement in the Executed tab and select Move to Named. You can access the statement from now on in the Named tab.
To quickly filter a statement in SQL Recall, enter partial information or an asterisk (*) as a wildcard character in the field above the Executed and Named tabs.
To set the maximum number of executed statements that can be saved before previous statements are overwritten, enter a value in Tools | Options | Editor | Tools.