OK, before someone goes off on me about this, yes, I am using a static recordset, and yes the stored procedure works (tested using a program written in C++; both the program and ASP page send ...

Technology Toolbox: VB.NET, C#, SQL Server "Yukon" All versions of SQL Server prior to SQL Server "Yukon" provide two ways to write procedural code that executes inside the database. The usual way is ...

SQL Server 2008 handles the EAV model's sparse matrix of entity values with sparse columns and filtered indexes. These two new features enable increasing the maximum number of columns in a table from ...

A connection to a database is a resource intensive operation that typically comprises a few steps. A channel of communication between the application and the database should be established before the ...

Leverage ADO.Net's ability to work in disconnected mode to enable your application to stay disconnected to the database, conserve the system resources, and reduce the network traffic Microsoft’s ...