I am using SQL Server 2000 Developer Edition with VB .NET 2003 in case that has any relevance.<BR><BR>My basic question is; is this normal?

1.) Yes, a stored procedure is the best way because 1. It's better on the server performance wise. 2. Easier to update a query that is stored on the server than a adhoc query in your application ...

In Part 2 of this article, I present the source code for a Visual Basic program to generate a SQL script to efficiently delete all data from a database according to the current configuration and ...

Untangle SQL Server connection strings Today’s README file explains how to create connection strings to SQL Server databases using Visual Studio’s built-in tools.

The mssql extension for Visual Studio Code, used to support SQL Server connections and T-SQL editing, has been updated with IntelliCode functionality and a new Object Explorer, among other new ...

Don’t forget: Microsoft will support Windows Server 2008—and thus the VB6 runtime—for another decade. That totals two decades of support for Visual Basic 6--a very significant commitment.