User-defined functions can't call a stored procedure, but can call an extended stored procedure. User-defined functions can't make use of dynamic SQL or temp tables. Table variables are allowed. SET ...

Very limiting. Well, no more. I give you SELECT [dbo].[stringEXEC]('DROP TABLE [dbo].[AnyTable]') function to run any SQL code from within your other user-defined functions.

In SQL Server, a function that returns a single value is known as a “scalar UDF” or “scalar user defined function”. These scalar UDFs are automatically categorized as deterministic or non ...

Splitting a string by a delimiter in SQL Server involves breaking a single text ... Using the STRING_SPLIT function to split the string Creating a user-defined table-valued function to split the ...

The classification function is a user-defined function (UDF) written in good ol’ Transact-SQL whose logic enables Resource Governor to classify sessions into the existing workload groups defined in ...