Extended Procedures Wizard (SQL Server)

From RapidSQL
Jump to: navigation, search

Go Up to Microsoft SQL Server Object Wizards

Extended Procedures are dynamic link libraries that can be used to load and execute application routines written in other programming languages, such as C or Visual Basic. Extended Procedures function and appear in the same manner as SQL Server stored procedures in that you can pass parameters to them and obtain results.

Extended stored procedures provide a method for calling procedural language functions from within the Adaptive Server.

Note: Extended procedures can only be created in the Master database.

To create a new Extended procedure using a wizard:

  1. Open a creation wizard for an extended procedure. For details, see Opening an Object Wizard.
  2. Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
  3. Finally, use the Execute button to create the object.

Extended Procedures (SQL Server) - Properties

When creating or editing an extended procedure, this tab/panel lets you work with the following settings:

Setting Description

Owner

Select the owner of the extended procedure.

Name

Provide a name for the extended procedure.

Library

Provide the name of the DLL containing the extended procedure.