你当前正在访问 Microsoft Azure Global Edition 技术文档网站。 如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站，请访问 https://docs.azure.cn。
Set statement
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
The set statement is used to set a request property for the duration of the query.
Request properties control how a query executes and returns results. They can be boolean flags, which are false by default, or have an integer value. A query may contain zero, one, or more set statements. Set statements affect only the tabular expression statements that trail them in the program order. Any two statements must be separated by a semicolon.
Request properties aren't formally a part of the Kusto Query Language and may be modified without being considered as a breaking language change.
Note
- To set request properties using T-SQL, see Set request properties.
- To set request properties using the Kusto client libraries, see Kusto Data ClientRequestProperties class.
Syntax
set OptionName [= OptionValue]
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| OptionName | string |
✔️ | The name of the request property. |
| OptionValue | ✔️ | The value of the request property. |
Example
set querytrace;
Events | take 100