Toad for SQL Server 7.4 - Installation Guide

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

1. Select the Stored Procedures node under the Programmability node in the Object Explorer.

2. 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.

3. 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.

Related Topics

About Stored Procedures

Set Extended Stored Procedure Properties

Note: This object is only available from the master database. You cannot create extended stored procedures on any other database.

To define properties for an extended stored procedure

1. Select the master database.

2. Select Extended Stored Procedures under the Programmability node in the Object Explorer.

3. Click .

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

   Path	Click to locate the DLL for the extended stored procedure.

Functions

About Functions

User-defined functions are saved T-SQL routines that return a value.

Notes:

• You cannot use functions to perform actions that would modify the global database state.

• You can change how objects display in the Object Explorer. For example, you can create custom categories or move objects out of existing categories (such as Programmability and Security) in Tools | Options | Explorer | Objects. See Object Options for more information.

Function Details

You can display details about a function by selecting it in the Object Explorer. The following describes the details associated with each function:

Related Topics

Create and Alter Functions