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: SQL Server Objects > Programmability > Stored Procedures > Create and Alter Stored Procedures

Create and Alter Stored Procedures

Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To create or alter a stored procedure

Select the Stored Procedures node under the Programmability node in the Object Explorer.
Select one of the following:
- Click to create a stored procedure.
- Select a stored procedure and click to create a stored procedure like the selected one.
- Select a stored procedure and click to alter it.

Complete the fields as necessary. Review the following for additional information:

General	Description
Parameters	Click to define parameters for this procedure.
Options	Description
Encryption	Select True to publish during SQL Server replication.
Recompile	Select True to compile the procedure at run time.
For replication	Select True to specify that the stored procedure is created for replication.
ANSI nulls	Select True to allow NULLs for procedures that use SQL-92 NULL handling.
Quoted identifier	Select True to identify any strings that use a double quotation mark delimiter as an object identifier.
Execution context	Select a user under which you want to execute the stored procedure.

Note: You can also write a script defining a procedure action and parameters in the Editor and click in the Editor toolbar. This invokes Create Stored Procedure dialog and Toad automatically recognizes parameters and SQL body.