Quickly insert large quantities of data records into a database table. Supports MySQL, Oracle and SQL Server. The purpose of this component is to allow large amounts of data to be batch inserted into a database table quickly and efficiently. This new version has been converted into a Service Application (new application type made available in version 11 from October 2020). A Service Application allows you to impose a better segmentation of modules and to encapsulate the main business services in your projects.

Component is to validate the document number of a CPF or Brazilian CNPJ, indicates whether it is a document with valid or invalid syntax.

The purpose of this application is to present practical examples of using advanced SQL commands for your daily life, such as: SQL Tips (WITH NOLOCK or READUNCOMMITTED), Recursion using CTEs, temporary tables at session and global level, Pivot Table, Unpivot Table, APPLY commands (CROSS APPLY and OUTER APPLY), SPLIT_SQL() and spatial data (geometry and geography). Demonstration of the use of the EncodeSql () function to guarantee the security of the operation in question, as well as a practical example of Dynamic Sorting in Advanced Query.