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

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

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

Microsoft would like you to use ADO to access your data, but is it the right solution for you? Follow along with our step-by-step example to learn more about this technology and see what advantages ...

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