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 ...

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 ...

Provisioning highly scalable databases as Web services with REST and SOAP data access and update protocols is one of 2008's hottest Web infrastructure topics. Web-Oriented Architecture (WOA) envisions ...

OK, this makes no sense. I have inherited a page that is using an ADO Command object to use a stored procedure to retrieve records from a SQL Server database. Here's the sample code (note that not all ...

Last month we looked at the upcoming MS SQL Server 2005 Beta 2. In this version, the programmability of SQL Server is not anymore restricted only to SQL statements. You can now create solutions in SQL ...

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 ...