Ars Technica

(SQL) Complex Inner & Outer Join Fails In ADO.NET But Not in SQL Anaylzer

I need to create a three table inner join. It works correctly in SQL Analyzer, but fails when I run it inside ADO.NET.<BR>Here is a simplified query of what I am trying to do:<BR><BR>SELECT a.ID, b.ID ...
Ars Technica

ASP, ADO, and RecordCount = -1 with SQL Server

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 ...
Visual Studio Magazine

Write .NET Code in SQL Server

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

.NET in SQL ServerÂ

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