Share via


README Execute user-defined function and process return code (OLE DB)

Executes user-defined function, prints return code. This sample is not supported on IA64.

Scenario

For more information on this sample, see How to: Execute a User-Defined Function and Process Return Code (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 that you add the following user-defined function, which you can find in the sample's scripts directory:

    USE AdventureWorks
    drop function fn_RectangleArea
    go
    
    CREATE FUNCTION fn_RectangleArea
       (@Width int, 
    @Height int )
    RETURNS int
    AS
    BEGIN
    
       RETURN ( @Width * @Height )
    END
    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_C.sln file and build it.

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

    MSBuild InitializeAndEstablishConnection_C.sln
    

Running the Sample

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

Change History

Release History

17 July 2006

Changed content:
  • Clarified and updated prerequistites 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