Database Design, "Leverage SQL Servers Cursorless Mode," by Bob Beauchemin [Visual Studio Magazine, December 2003]


This is an example of using SQL Server default resultset through a SqlDataReader.

Execute the Transact-SQL script in Query Analyzer to create and populate the table.

Uncomment the transaction code to try different transaction isolation levels.