Export (0) Print
Expand All
Expand Minimize

README Fetching Columns Using IRow::GetColumns (or IRow::Open) and ISequentialStream

SQL Server 2005

Updated: 17 July 2006

This sample shows how to fetch a single row using IRow. This sample is not supported on IA64.

For more information on this sample, see Fetching Columns Using IRow::GetColumns (or IRow::Open) and ISequentialStream in Books Online.

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

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

  • 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 Transact-SQL statements, which you can find in the sample's scripts directory:
    USE AdventureWorks
    GO
    
    IF EXISTS (SELECT name FROM sysobjects WHERE name = 'MyTable')
         DROP TABLE MyTable
    GO
    
    CREATE TABLE MyTable
    (
         col1  int,
         col2  varchar(50),
         col3  char(50),
         col4  datetime,
         col5  float,
         col6  money,
         col7  sql_variant,
         col8  binary(50),
         col9  text,
         col10 image
    )
    GO
    
    /* Enter data. */
    INSERT INTO MyTable
    values
    (
         10,
         'abcdefghijklmnopqrstuvwxyz',
         'ABCDEFGHIJKLMNOPQRSTUVWXYZ',
         '11/1/1999 11:52 AM',
         3.14,
         99.95,
         CONVERT(nchar(50), N'AbCdEfGhIjKlMnOpQrStUvWxYz'),
         0x123456789,
         REPLICATE('AAAAABBBBB', 500),
         REPLICATE(0x123456789, 500)
    )
    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 FetchColumns_A.sln file and build it.
  • If you are using MSBuild.exe, invoke MSBuild.exe at a command prompt, passing it the FetchColumns_A.sln file:
    MSBuild FetchColumns_A.sln
    

  • From Visual Studio, invoke Start Without Debugging (CTRL+F5).
  • If you built with MSBuild.exe, invoke FetchColumns_A.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.

Community Additions

ADD
Show:
© 2014 Microsoft