Search Results for "sql query"

The server is accessed through the standard GET, POST methods, the parameters of which specify SQL, written in JSON format. The query result is returned as an array of JSON format.

...) and used like a dataset. For use through the designer, a wrapper component is available that dynamically creates the specialized data objects at run time. For ease of construction and programmatic manipulation of SQL queries SFBusinessData also provides a SQL generator, which is directly available through the data classes, but can also be used alone. This SQL generator works independently of the database and without having to deposit hard-coded SQL queries.

...... - columns, indexes, primary and foreign keys) with F3 and F5. - Export table or view data to another TC panel in different formats (Excel, HTML, XML, CSV, Text, RTF). - Internal query lister/editor. Shows and edits table and view records, executes SP and SQL-queries. Print and export data. - Server and local filters. - Data sorting and filtering with one mouse click. - Plugin can work with BLOB fields (TEXT, IMAGE, BYNARY). Text/Image/Hex/HTML modes.

SqlClient Data Access Components (SqlClientDAC) is a feature-rich and high-performance library of components that provides native connectivity to SQL Server from Delphi. SqlClientDAC-based applications connect to SQL Server directly through the ADO.Net SqlClient, which is a .NET Framework Data Provider for SQL Server. SqlClientDAC is designed to help programmers develop faster and cleaner SQL Server database applications. SqlClientDAC uses its own protocol to communicate with SQL Server...

ADO.Net Data Access Components (DAC) for Delphi is the fastest and most reliable database connectivity solutions for any database using ADO.Net technology in Delphi. It provides data access to data sources such as SQL Server, Oracle and to data sources exposed through OLE DB and ODBC using ADO.Net data provider framework. ADO.Net DAC for Delphi is an enterprise solution with highest performance and unlimited possibilities. Data-sharing consumer applications can use ADO.NET DAC for Delphi...

OLE DB Data Access Components (OLEDBDAC) is a feature-rich and high-performance library of components that provides data access for data sources exposed through OLE DB from Delphi for both 32-bit and 64-bit Windows platforms. OLEDBDAC-based applications connects to any data source exposed through OLE DB using the .NET Framework Data Provider for OLE DB. OLEDBDAC aims to assist programmers in developing of fast and native database applications whose data source is exposed through OLE DB....

This tool will compare 2 tables one way, during the run it will create sql scripts of all the changes to all the fields in the selected table. Both tables should have the same structure during the run. Insert and Update query's are created during the run and can be saved for later execution. Joins can be added to the from query if only certain records should be compared, as long as the end result only have the current table fields visible.

Find this useful tool to run scripts or extracting inserts from a table on MSSQL. Query execution runs each query separate, that is separated with a ";". The reason for this is because Views and Procedure creation expects to be executed separate from other queries which resulted in me having to run several queries 1 by 1 and thus resulted in me creating this tool. Insert script creation can happen from a conditional query.

EstSearchDialogs is a Delphi component set to create powerful search functionality in your application by building a SQL statement and visualy configuring how your user may search on the query result. Use BDE, DB Express, ADO, IB Express, Zeos or custom.

CDDC-DBManager is an OpenSource database manager which supports MySQL, PostgreSQL, FireBird, InterBase, Sybase, Oracle, Microsoft Access and Microsoft SQL Server databases servers. Features database structures management, data editor and SQL Query Tool.

ssql is a utility that extends osql/isql utilities for microsoft sql server 2000. It allows to specify a parameter file that contains the value of query parameters that will be replaced before to execute the query. The format is the same of a .tql fi