Unfortunately, SQL Server never fully integrated scalar UDF support into its execution ... Consider this simple function: CREATE FUNCTION dbo.discount_price(@price DECIMAL(12,2), @discount DECIMAL ...

If you ever need to sort character strings stored in SQL Server fields ... Now that I have my helper function, I can write the sorting function. This function, udf_SortString, accepts a string ...

If you’re running SQL Server 2008 or later, you might want to investigate Resource Governor as an alternative. Resource Governor lets you create limits ... a classification function. The ...