Executes the Transact-SQL Query against the target server.When used in a condition On Demand is the only supported evaluation ...

Executes the Transact-SQL Query against the target server.When used in a condition On Demand is the only supported evaluation mode (meaning it can only be evaluated as client side).If more than one column is provided, an exception will be thrown.The select statement can use the following variables which will be substituted at execution time using ADO.Net parameter substitution:
@object_name - Corresponds to the name field in sys.objects. The variable will be replaced with the name of the current object.
@object_schema - Corresponds to the name field in sys.schemas. The variable will be replaced with the name of the schema for the current object, if applicable.