stored procedure

A stored procedure is a pre-compiled group of SQL statements. Stored procedures allow a group of sequentially performed actions to be executed using a single SQL statement. A stored procedure is usually called by another program to be executed; it is not automatically executed in response to an event. Stored procedures can be used as shortcuts for frequently used collections of SQL statements or to provide additional functionality. Users of the AVEVA Historian can use any of the system stored procedures provided by Microsoft SQL Server, plus the system stored procedures supplied with the historian. System stored procedures that are provided with the historian begin with "aa" or "we". User-defined stored procedures are also supported.