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.
Complete the fields as necessary. Review the following for additional information:
General |
Description |
Parameters |
Click |
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.
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
Select the master database.
Click .
Complete the fields as necessary. Review the following for additional information:
Path |
Click |
User-defined functions are saved T-SQL routines that return a value.
Notes:
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.
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. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center