SQL Eval Function API
Overview
Let's take a very short overview with the API
SELECT SQLNET::New('x+y').ValueInt('x', 1).ValueInt('y', 2).EvalInt() as Result
include component-try-it.html href='http://sqlfiddle.com/#!18/9eecb/1123' %}
- SQLNET: A CLR Type created by Eval SQL.NET library
- "::": This is how you call static method in SQL CLR
- New: A static method which creates a new instance of SQLNET Type
- ValueInt: Sets a int value for a specific parameter name used in the expression
- EvalInt: Evaluates the expression and return a result of type INT