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 ...

To create a SQL Server CLR function, create a project of type "Visual Basic SQL CLR Database Project" under the Database, SQL Server template category. Then add a new item of type "User-Defined ...

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 ...