Top "User-defined-functions" questions

A function provided by the user of a program or an environment most often for spreadsheet type applications or database applications.

How to strip all non-alphabetic characters from string in SQL Server?

How could you remove all characters that are not alphabetic from a string? What about non-alphanumeric? Does this have to …

sql-server parsing user-defined-functions alphanumeric alphabetic
SQL User Defined Function Within Select

I have a user defined function in SQL called getBuisnessDays it takes @startdate and @enddate and returns the number of …

sql sql-server select user-defined-functions
How to determine the number of days in a month in SQL Server?

I need to determine the number of days in a month for a given date in SQL Server. Is there …

sql sql-server datetime date user-defined-functions
Return multiple values from a SQL Server function

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

tsql user-defined-functions
Multi-statement Table Valued Function vs Inline Table Valued Function

A few examples to show, just incase: Inline Table Valued CREATE FUNCTION MyNS.GetUnshippedOrders() RETURNS TABLE AS RETURN SELECT a.…

sql sql-server sql-server-2008 tsql user-defined-functions
Overriding a JavaScript function while referencing the original

I have a function, a(), that I want to override, but also have the original a() be performed in an …

javascript overriding user-defined-functions
Hive: Convert String to Integer

I am looking for a Built-in UDF to convert values of a string column to integer in my hive table …

string hive user-defined-functions hiveql
How to call a MySQL stored procedure from within PHP code?

I have stored procedure that I created in MySQL and want PHP to call that stored procedure. What is the …

php mysql stored-procedures mysqli user-defined-functions
Pass table as parameter into sql server UDF

I'd like to pass a table as a parameter into a scaler UDF. I'd also prefer to restrict the parameter …

sql sql-server sql-server-2005 parameters user-defined-functions
Declare variable in table valued function

How can I declare a variable in a table valued function? (like in my title)

sql-server function user-defined-functions