如果未为表值函数指定输入参数,SQL 适配器将使用 DEFAULT 关键字 (keyword) 在内部调用函数。 这意味着使用定义函数时指定的默认值执行表值函数。 详细信息: 使用带有 BizTalk Server 的 SQL 适配器在 SQL Server 中调用表值函数,请参阅使用BizTalk Server 在 SQL Server 中调用 Ta...
] {table_name | view_name | table_valued_function_name } | AS TYPE [ schema_name.]table_type_name | AS FOR XML } Syntax for In-Memory OLTP. syntaxsql Copy -- Execute a natively compiled, scalar user-defined function [ { EXEC | EXECUTE } ] { [ @return_status = ] { module...
ExecuteAsCaller property class of TableValuedFunction 命名空间: Microsoft.SqlServer.Dac.Model 程序集: Microsoft.SqlServer.Dac.Extensions(在 Microsoft.SqlServer.Dac.Extensions.dll 中) 语法 C# 复制 public static ModelPropertyClass ExecuteAsCaller { get; internal set; } 属性值 类型:Microsoft.SqlServer...
TableValuedFunctionReturnType TableXmlCompressionOption TargetDeclaration TargetRecoveryTimeDatabaseOption TemporalClause TemporalClauseType TemporalRetentionPeriodUnit TextModificationStatement ThrowStatement TimeUnit TopRowFilter TransactionStatement TriggerAction TriggerActionType TriggerEnforcement TriggerObject ...
Define the execution context of functions (except inline table-valued functions), procedures, queues, and triggers.
The name of the database containing the table, view or table valued function. schema_name The name of the schema owning the table, view or table valued function. table_name | view_name | table_valued_function_name Specifies that the columns returned will be those specified in the table, ...
Assume that you create a synonym for a stored procedure that takes a table-valued parameter in Microsoft SQL Server 2014 or 2016. When you execute that stored procedure by using the synonym from a remot...
Define the execution context of functions (except inline table-valued functions), procedures, queues, and triggers.
Is an optional integer variable that stores the return status of a module. This variable must be declared in the batch, stored procedure, or function before it is used in an EXECUTE statement. When used to invoke a scalar-valued user-defined function, the@return\_statusvariable can be of ...
Assume that you create a synonym for a stored procedure that takes a table-valued parameter in Microsoft SQL Server 2014 or 2016. When you execute that stored procedure by using the synonym from a remot...