The Transact-SQL and CLR scalar functions in SQL Server are surfaced as operations in [!INCLUDEadaptersql]. The operation name in the [!INCLUDEadaptersqlshort] is the same as the name of the scalar ...

Learn the differences between scalar and table-valued functions in T-SQL and how to use them for better query performance and readability.