Tutorials, Samples, and Sample Databases: New and Updated Topics (14 April 2006)

New: 14 April 2006

In the 14 April 2006 release of SQL Server Books Online, the following topics have either been added to Books Online or have had content that has been updated.

Topic Categories

New Tutorials

New Conceptual and Task Topics

Updated Tutorials

Updated Conceptual and Task Topics

New Tutorials

Creating a Basic Package Using a Wizard

Deploying Packages Tutorial

Applying Security Filters to Report Model Items

Customizing Report Builder Clickthrough Reports

Using XML Data in a Report

Writing Transact-SQL Statements Tutorial

Arrow icon used with Back to Top linkBack to Top

New Conceptual and Task Topics

EmailLogProvider Sample

Excel2 Custom Connection Manager Sample

HtmlLogProvider Sample

README BulkCopyFormatAndData

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

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

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

README Fetching Columns Using IRow::GetColumns (OLE DB)

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

README How to bulk copy a SELECT result set (ODBC)

README How to bulk copy data from program variables (ODBC)

README How to bulk copy data using IRowsetFastLoad (OLE DB)

README How to bulk copy without a format file (ODBC)

README How to create a bulk copy format file (ODBC)

README How to enumerate OLE DB data sources (OLE DB)

README How to fetch rows from a result set (OLE DB)

README How to log long-running queries (ODBC)

README How to obtain FAST_FORWARD cursor

README How to process ODBC errors (ODBC)

README How to process return codes and output parameters (ODBC)

README How to profile driver performance data (ODBC)

README How to retrieve rows using bookmarks (OLE DB)

README How to set large data (OLE DB)

README UseDataAtExecutionColumns

README UseDataAtExecutionParameters

Sales Orders Sample for Devices

Arrow icon used with Back to Top linkBack to Top

Updated Tutorials

Creating a Simple ETL Package Tutorial: Lesson Packages

SQL Server 2005 Analysis Services Tutorial

Arrow icon used with Back to Top linkBack to Top

Updated Conceptual and Task Topics

Array Parameter Sample

Flight Sample

FlightNmo Sample

Inventory Tracker Sample

Newsletter Sample

Package Samples

Profit Margin Sample

Programming Samples

Readme_Storefront

Replication ActiveX Controls Sample

Report Builder Report Samples

Report Model Samples

SMOTableList Sample

Sql Server Custom Connection Manager Sample

Stock Sample

Arrow icon used with Back to Top linkBack to Top