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

Download (739 KB) Website Link to this page