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.

Spark column string replace when present in other column (row)

I would like to remove strings from col1 that are present in col2: val df = spark.createDataFrame(Seq( ("Hi I …

scala apache-spark user-defined-functions
Function Overloading and UDF in Excel VBA

I'm using Excel VBA to a write a UDF. I would like to overload my own UDF with a couple …

excel user-defined-functions vba
How do I convert a WrappedArray column in spark dataframe to Strings?

I am trying to convert a column which contains Array[String] to String, but I consistently get this error org.…

scala apache-spark dataframe apache-spark-sql user-defined-functions
How to add levenshtein function in mysql?

I got the code for levenshtein distance for mysql form "http://kristiannissen.wordpress.com/2010/07/08/mysql-levenshtein/" but, how to add that …

mysql user-defined-functions levenshtein-distance
SQL Server 2008 - How do i return a User-Defined Table Type from a Table-Valued Function?

Here's my user-defined table type... CREATE TYPE [dbo].[FooType] AS TABLE( [Bar] [INT], ) This is what ive had to do …

sql-server tsql sql-server-2008 user-defined-functions user-defined-types
Finding all Stored procedures calling a function

How can I find out all the stored procedures that are calling a particular user defined function in SQL Server 2005. …

sql sql-server-2005 user-defined-functions
User Defined Functions NOT recalculating

I recently took a large, stable XLSM file, and split it apart into an XLAM and XLSX. Thousands of cells …

excel vba user-defined-functions xlsx xlsm
How can I pass extra parameters to UDFs in Spark SQL?

I want to parse the date columns in a DataFrame, and for each date column, the resolution for the date …

scala apache-spark apache-spark-sql user-defined-functions
Why is TRY-CATCH block not allowed inside UDFs?

Why doesn't SQL Server support TRY-CATCH blocks inside UDFs? If we're talking about scalar UDFs, which are mostly used for …

tsql user-defined-functions
Execute table-valued function on multiple rows?

Given a table-valued function such as dbo.Split() from "T-SQL: Opposite to string concatenation - how to split string into …

sql sql-server-2005 tsql user-defined-functions