In SQL Server, a function that returns a single value is known as a “scalar UDF” or ... CREATE FUNCTION dbo.discount_price(@ ... the sys.sql_modules catalog view includes a property called ...

Once deployed to the SQL Server, the CLR function appears in the Programmability, Functions, Scalar-valued Functions folder of the database, much like a T-SQL user-defined function. See Figure 1 for a ...

Indexed views. In SQL Server 2000 and 2005, you have the ability to add indexes to views. ... create the view because it is only a T-SQL query definition. Once the view is created, ...

This function is capable of being remoted to SQL Server 2012 servers and later. Unfortunately, it won't be remoted to servers that have a version below SQL Server 2012. SELECT DATETIMEFROMPARTS (2012, ...