ChronicleRule Element (ADF)
Provides a location for defining one or more Transact-SQL statements that maintain data in event chronicle tables.
语法
<EventClasses>
<EventClass>
...
<ChronicleRule>
Element Characteristics
| Characteristic | Description |
|---|---|
Data type and length |
None. |
Default value |
None. |
Occurrence |
Optional once per EventClass element. (See Remarks.) |
Updates |
Can be added and deleted when updating the application. |
Element Relationships
| Relationship | Elements |
|---|---|
Parent element |
|
Child elements |
RuleName Element for ChronicleRule (ADF) |
备注
If you are using event chronicle tables, you must define a chronicle rule. The chronicle rule contains the Transact-SQL queries that manipulate the data in the event chronicle tables.
示例
The following example shows a ChronicleRule element for creating an event chronicle rule named StockEventChronRule. This rule first inserts new stock data into the chronicle table, and then updates existing stock records in the chronicle table. The ActionTimeout value of P0DT00H05M00S gives the rule five minutes to complete successfully.
<ChronicleRule>
<RuleName>StockEventChronRule</RuleName>
<Action>
-- Insert New Stock Symbols with Prices
INSERT dbo.StockEventsChron (StockSymbol, StockPrice)
SELECT e.StockSymbol, e.StockPrice
FROM dbo.StockEvents AS e
WHERE e.StockSymbol NOT IN
(SELECT StockSymbol FROM dbo.StockEventsChron);
-- Update Existing Stock Symbols with New Prices
UPDATE dbo.StockEventsChron
SET StockPrice = e.StockPrice
FROM dbo.StockEvents AS e
JOIN dbo.StockEventsChron AS c
ON e.StockSymbol = c.StockSymbol
WHERE e.StockPrice > c.StockPrice;
</Action>
<ActionTimeout>P0DT00H05M00S</ActionTimeout>
</ChronicleRule>
请参阅
参考
Application Definition File Reference
其他资源
为事件类定义历史记录
定义事件历史记录规则
更新实例和应用程序