User-defined functions cannot be used to perform actions that modify the database state. I found one way to make INSERT, UPDATE or DELETE in function using xp_cmdshell.

The purpose here is a searchable text of the user defined function definitions in a database for database change analysis, if something like a full SQL procedure or purposed helper program is easier, I will …

For Transact-SQL functions, all data types, including CLR user-defined types and user-defined table types, are allowed except the timestamp data type. You can use user-defined table types.

Jul 14, 2016 · Aggregate Functions User-Defined Aggregates (UDA) are aggregates similar to SUM(), COUNT(), MIN(), MAX(), etc. and typically require a GROUP BY clause. These can only be created …

Sep 28, 2009 · I'm writing a user-defined function in SQL Server 2008. I know that functions cannot raise errors in the usual way - if you try to include the RAISERROR statement SQL returns: Msg 443, …

Jun 3, 2015 · "AF" is not considered a "function" in terms of SQL Server's object metadata even though it stands for AGGREGATE_FUNCTION. It is more clear that an Aggregate is an object type different …

Nov 10, 2008 · How would I return multiple values (say, a number and a string) from a user-defined function in SQL Server?

Dec 26, 2018 · Can anyone explain what is the exact difference between stored procedures and user defined functions, and in which context each is useful?

I have a user defined function in SQL called getBuisnessDays it takes @startdate and @enddate and returns the number of business days between the two dates. How can I call that function within my …

Dec 21, 2009 · If a statement return rows doing a simple select over the data base, is there performance difference between implement it using Function and Procedures? I know it is preferable to do it using …