Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The Transact-SQL and CLR scalar functions in SQL Server are surfaced as operations in Microsoft BizTalk Adapter for SQL Server. The operation name in the SQL adapter is the same as the name of the scalar function in SQL Server.
All the parameters in the scalar function are exposed in the corresponding operation. The return value of the operation in the SQL adapter is the same as the return value defined in the scalar function in SQL Server.
For more information about executing scalar functions, see Invoke Scalar Functions in SQL Server using BizTalk Server.