JavaScript EditorDhtml editor     Free javascript download 



Main Page

You can call an extended stored procedure from an SQL script file.

To call an extended stored procedure

  1. Make sure the active project is set to the database project created in Registering an Extended Stored Procedure.

  2. On the File menu, click New, and then click File.

  3. In the New Files dialog box, click SQL Script File from the list of file types.

  4. In the Name box, enter the name of your script file, and then click Open.

    You now have a blank script file in the Visual C++ editor. If the extended stored procedure's name is xp_MyXp, the following code would cause the extended stored procedure to be executed:

    В CopyCode imageCopy Code
    EXEC xp_MyXp
  5. To run the script, right-click the editor window, and then click.

If the extended stored procedure produces any output, you can view the output in the Results pane.

NoteNote

SQLВ Server does not perform parameter checking on extended stored procedures. It is up to the caller of the extended stored procedure to know the required parameters and then pass them accordingly.

See Also

Tasks

Create an Extended Stored Procedure
Debug an Extended Stored Procedure

Concepts

Extended Stored Procedures
Adding Functionality to an Extended Stored Procedure
Registering an Extended Stored Procedure



JavaScript EditorDhtml editor     Free javascript download