WS Testtool SQL Function
With the WS Testtool, existing machines can be connected to an MS SQL server as a retrofit at low cost. The data of your machines are transferred to the WS Testtool via the communication interface WS Protocol and stored there in a SQL database. A predefined stored procedure is accessed on the SQL instance – the data can thus be processed individually. An example procedure for the storage of data in intervals in a relational database, which is easy on memory space, is supplied including instructions for the creation of the databases and indices. The procedure contains two different bit parameters which are set after adding a data point, after establishing a connection to a WS-Server and after starting a cyclic query to signal that new time intervals have to be created. This prevents wrong end times of the time intervals.