Well, optimization of SQL in general and VB/SQL (ADO.NET) apps in particular is a huge topic. There is quite a bit on MSDN if you search for it, including some information aimed directly at VB/C# ...

SQL injection attacks often happen when applications don't screen/validate user input before they send it to a database. If a user can send commands to the database, and the database executes these ...

SQL Bulk Insert has been tuned over the years to work well with the Microsoft .NET Framework. This tutorial shows you how to take advantage of its power.

How to Connect to SQL From VB6. If your business does any programming in Windows, then a basic knowledge of VB6 programming concepts is essential. Windows provides a set of objects and functions ...

Check out the latest Visual Studio third-party add-ons, including one that helps you edit your database's data and properties during a debug session.

MS SQL doesn't allow that, and I seriously doubt that MySQL does either. You're probably going to have to use string concatenation, unfortunately.

vba-sql-formatter A4セルにSQLを貼り付けてFormatボタンをクリックするとB4セルに整形後のSQLが出力されます。