Runs a Transact-SQL query against a target instance of SQL Server. The On Demand condition is the only supported evaluation ...

Runs a Transact-SQL query against a target instance of SQL Server. The On Demand condition is the only supported evaluation mode for ExecuteSql. Only one table column can be specified in a SELECT statement; more than one column will throw an exception. A SELECT statement can use the following variables, which will be substituted at run time by using ADO.NET parameter substitution:
@@ObjectName - corresponds to the name field in sys.objects. The variable will be replaced with the name of the current object.
@@SchemaName - corresponds to the name field in sys.schemas. The variable will be replaced with the schema for the current object if the current object belongs to a schema.