Share via


README Execute stored procedure (using RPC syntax) and process return codes and output parameters (OLE DB)

Demonstrates processing a rowset, a return code, and an output parameter. This sample is not supported on IA64.

Scenario

For more information on this sample, see How to: Execute a Stored Procedure (Using RPC Syntax) and Process Return Codes and Output Parameters (OLE DB) in Books Online.

Languages

This sample uses Transact-SQL and Visual C++.

Prerequisites

Before running this sample, make sure the following software is installed:

Building the Sample

  • This sample connects to your computer's default SQL Server instance. To connect to a named instance, change the connection string from L"(local)" to L"(local)\name", where name is the named instance. By default, SQL Server Express installs to a named instance.

  • The sample requires you to execute the following stored procedure, which you can find in the sample's scripts directory:

    USE AdventureWorks
    DROP PROCEDURE myProc
    GO
    
    CREATE PROCEDURE myProc 
        @inparam nvarchar(5),
        @outparam int OUTPUT
    
    AS
    SELECT Color, ListPrice 
    FROM Production.Product WHERE Size > @inparam
    SELECT @outparam = 100
    
    IF  (@outparam > 0)
        RETURN 999
    ELSE
        RETURN 888
    GO
    

    In SQL Server Management Studio, load and execute the Scripts\setup.sql script or execute the following command in a Command Prompt window:

    sqlcmd -E -I -i Scripts\setup.sql
    
  • If you are using Visual Studio, load the InitializeAndEstablishConnection_B.sln file and build it.

  • If you are using MSBuild.exe, invoke MSBuild.exe at a command prompt, passing it the InitializeAndEstablishConnection_B.sln file:

    MSBuild InitializeAndEstablishConnection_B.sln
    

Running the Sample

  • From Visual Studio, invoke Start Without Debugging (CTRL+F5).
  • If you built with MSBuild.exe, invoke InitializeAndEstablishConnection_B.exe.

Change History

Release History

17 July 2006

Changed content:
  • Clarified and updated prerequisites including the Web site for downloading the samples.
New content:
  • Added information on connecting to a named instance.

See Also

Concepts

Data Access Samples

Help and Information

Getting SQL Server 2005 Assistance