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/Scala repeated calls to withColumn() using the same function on multiple columns

I currently have code in which I repeatedly apply the same procedure to multiple DataFrame Columns via multiple chains of .…

scala apache-spark dataframe apache-spark-sql user-defined-functions
How to subtract a column of days from a column of dates in Pyspark?

Given the following PySpark DataFrame df = sqlContext.createDataFrame([('2015-01-15', 10), ('2015-02-15', 5)], ('date_col', 'days_col')) …

python apache-spark pyspark apache-spark-sql user-defined-functions
What does it mean by "Non-deterministic User-Defined functions can be used in a deterministic manner"?

According to MSDN SQL BOL (Books Online) page on Deterministic and Nondeterministic Functions, non-deterministic functions can be used "in a …

sql sql-server user-defined-functions deterministic non-deterministic
Can T-SQL function return user-defined table type?

I have my own type: CREATE TYPE MyType AS TABLE ( foo INT ) and a function receiving it as a parameter: …

sql-server tsql sql-server-2008 function user-defined-functions
SQL Server 2008 and HashBytes

I have quite a large nvarchar which I wish to pass to the HashBytes function. I get the error: "String …

sql-server-2008 hash user-defined-functions sqlclr
Is it possible to define a local function in a TSQL query?

I have a complex expression calculating a value from a date that I have to use on multiple date columns. …

sql-server tsql user-defined-functions
Pass table as parameter to SQLCLR TV-UDF

We have a third-party DLL that can operate on a DataTable of source information and generate some useful values, and …

c# sql-server-2008 sqlclr user-defined-functions
What does "Microsoft Office Excel is waiting for another application to complete an OLE action." mean?

I have a working RTD Excel automation add-in similar to the one described here. Intermittently, while attempting to load a …

excel user-defined-functions rtd excel-udf vba
Difference between operator and function in C++?

I could use some help understanding the following in C++, particularly the difference between an operator and a function: What …

c++ operators user-defined-functions
Why is a UDF so much slower than a subquery?

I have a case where I need to translate (lookup) several values from the same table. The first way I …

sql sql-server performance sql-server-2008 user-defined-functions