Assert
Short Description
The Assert step is used to verify a condition
Detailed Description​
The Assert step is typically used to either continue execution, or stop it. It evaluates an expression based on the data returned and if the expression returns NULL, execution is stopped, otherwise the row is passed up to the next step unchanged and execution continues.
Additional Links​
- Microsoft Documentation - Showplan Logical and Physical Operators Reference
- Microsoft Documentation - Explain Plans
- Plansplaining - Hugo Kornelis' Blog series
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.