Database and SQL

Main page▹Control Web Examples▹Alarms, archiving, database and backup	23.9.2020

Database and SQL

Communication with databases and SQL language

SQL Tutorial

Explanation of basic SQL statements and their use in the Control Web system (download...)

Asynchronous processing of SQL statements

Processing of the SQL statements using a sql virtual instrument operating in asynchronous mode, including queuing of SQL statements and automatically re-establishing a broken connection to the database. (download...)

The export database data to CSV file

The example demonstrates the export of data from a database obtained by an SQL query to a CSV file via the OCL procedure Export of the sql virtual instrument or by using the BCP.EXE and SQLCMD.EXE utilities. (download...)

How to call stored procedure in SQL server

Example of calling stored procedures in SQL server (download...)

How to obtain the @@IDENTITY value after inserting a record

The sample application shows how to obtain the @@IDENTITY value after inserting a record (download...)

\|	About company	\|	Products	\|	Technical support	\|	Software download	\|	Documents download	\|
Moravian Instruments, Masarykova 1148, Zlin 4, CZ-76302, Czech Republic