DS SQL Tools

DS SQL Tools is an invaluable tool for the serious database programmer. This first release of the library provides 2 sets of functions. One that allows validation of SQL queries against the data source and another that enables the programmer to predict the size of a result set without executing the query against the database.

DS SQL Tools can be useful in a variety of scenarios whenever one of the following is needed:

Syntax checking and validation against the actual database structure of user or runtime generated queries. Estimation of result-set size (number of rows and data size) without query execution - useful for predicting execution time and required storage space for export functions etc... DS SQL Tools works with MS SQL Server 6.5 and 7.0 (SQL Sever 6.5 does not support result-set size prediction)

DS SQL Tools is a set of COM components and can therefore be used with Scripting languages (VBScript, JavaScript), Visual Basic (Versions 4 and up), VBA (Word, Excel, Access ...), VC++, BC++, Delphi, Power Builder and any other COM compliant software package.

Note:

DS SQL Tools works with MS SQL Server 6.5, 7 and 2000 (SQL Sever 6.5 does not support result-set size prediction)

DS SQL Tools ships in a light weight DLL (48K) and can be used in any environment that supports COM automation.