SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer ...

DATEFROMPARTS is capable of being remoted only to SQL Server 2012 or later. Unlike other functions previously mentioned, all parameters are required, and it doesn't accept a style or culture parameter ...

the cost of caching the function parameters and results may have outstripped the benefit. However, that’s not the only problem with scalar UDFs. Another issue with scalar UDFs in SQL Server is ...

Taking a step back before building that function and clearly defining what parameters should be added is an important part of function design. There are numerous ways this can happen. You can create ...

Sometimes using ValidateSet isn't enough -- for instance, when you have multiple functions with the same parameter that you need to perform a task on. PowerShell has a data type called an enum, which ...