Chat now with support
Chat with Support

Toad for SQL Server 7.4 - Installation Guide

SQL Server Objects
Edit Permissions on Objects Databases Tables Create and Alter Views Indexes Programmability Create and Alter Synonyms Security Storage Create and Alter Sequences Table, Database and Server Triggers Management Agent

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

Set Extended Stored Procedure Properties

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

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:

Use this tab... To display...

Parameters

Characteristics about the function such as position, name, data type, and length.

Dependencies

Dependent function objects and the objects that contain reference to the function.

Extended Properties

Extended Properties you define to store additional metadata for this object.

Script

SQL statements for the selected object.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating