SQL Server Samples Portal Page > SQL Server Data Programming Product Samples
SQL Server 2008 RC0 product samples are
now available.
This project contains Data Programming samples released with Microsoft SQL Server product. These samples are in the following five categories: ADO, ODBC, and OLEDB. If you are interested in contributing Data Programming samples, please let us know by posting in the developers' forum.
To download these samples click on the Releases tab (or click
here), optionally select another (older) release, then click on the Windows Installer package (MSI file) which matches the architecture of the installation computer.
For information about how to use CodePlex to access SQL Server samples, click
here.
To download samples databases, click
here and then click the appropriate MSI file.
For release notes and brief descriptions of all the sample databases and code, including restrictions on SQL Express and Vista, click
here.
ADO.NET
| Sample | SQL Server 2005 | SQL Server 2008 |
| Large Binary Object (LOB) Handling using ADO.Net | SS2005 | n/a |
| MARS | SS2005 | n/a |
ODBC
OLE DB
| Sample | SQL Server 2005 | SQL Server 2008 |
| Enhanced Date/Time Features in SQL Server 2008 | n/a | SS2008 |
| Execute stored procedure (using ODBC CALL syntax) and process return codes and output parameters (OLE DB) | SS2005 | SS2008 |
| Execute stored procedure (using RPC syntax) and process return codes and output parameters (OLE DB) | SS2005 | SS2008 |
| Execute user-defined function and process return code (OLE DB) | SS2005 | SS2008 |
| Fetching Columns Using IRow::GetColumns (OLE DB) | SS2005 | SS2008 |
| Fetching Columns Using IRow::GetColumns (or IRow::Open) and ISequentialStream | SS2005 | SS2008 |
| How to bulk copy data using IRowsetFastLoad (OLE DB) | SS2005 | SS2008 |
| How to enumerate OLE DB data sources (OLE DB) | SS2005 | SS2008 |
| How to fetch rows from a result set (OLE DB) | SS2005 | SS2008 |
| How to obtain FAST_FORWARD cursor | SS2005 | SS2008 |
| How to retrieve rows using bookmarks (OLE DB) | SS2005 | SS2008 |
| How to set large data (OLE DB) | SS2005 | SS2008 |
| Read filestream column to file using IBCPSession (OLE DB) | n/a | SS2008 |
| Retrieve data from Filestream column using ISequentialStream (OLE DB) | n/a | SS2008 |
| Send data to a filestream column using ISequentialStream bound to ICommandText parameter (OLE DB) | n/a | SS2008 |
| Use IRowsetFastUpload interface to send data to a filestream column (OLE DB) | n/a | SS2008 |
| Changing a SQL Server Authentication User Password (OLE DB) | n/a | SS2008 |
| Displaying Column and Catalog Metadata for Sparse Columns (OLE DB) | n/a | SS2008 |
| Integrated Kerberos Authentication Sample (OLE DB) | n/a | SS2008 |
| Sending BLOB Data to SQL SERVER Using IROWSETFASTLOAD and ISEQUENTIALSTREAM | n/a | SS2008 |
| Table-Valued Parameters | n/a | SS2008 |
