How to use [mssql.scalar]

The reference page of mssql.scalar has its arguments, constraints and declaration.

Executes an arbitrary SQL statement, and returns the result as a scalar value to caller