Execute Scalar Functions in SQL Server using the SQL adapter
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.
See Also
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for