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.

TSQL - If..Else statement inside Table-Valued Functions - cant go through

Before posting I have read few articles about developing USD functions, but have not encountered solutions for my problem... which …

sql sql-server database tsql user-defined-functions
COLLECT_SET() in Hive, keep duplicates?

Is there a way to keep the duplicates in a collected set in Hive, or simulate the sort of aggregate …

java hadoop user-defined-functions hive
Derive multiple columns from a single column in a Spark DataFrame

I have a DF with a huge parseable metadata as a single string column in a Dataframe, lets call it …

scala apache-spark dataframe apache-spark-sql user-defined-functions
TypeError: got an unexpected keyword argument

The seemingly simple code below throws the following error: Traceback (most recent call last): File "/home/nirmal/process.py", line 165, …

python apache-spark pyspark apache-spark-sql user-defined-functions
How to pass parameters to Table Valued Function

I want to do something like select * from tvfHello(@param) where @param in (Select ID from Users)

sql-server sql-server-2005 user-defined-functions
How to add description to functions and function parameters?

I'm writing a VB.NET function with a ton of overloads. I've seen that most .NET functions have parameter descriptions …

vb.net user-defined-functions
Adding code to a javascript function programmatically

I'm attempting to customize an existing JS library without modifying the original JS code. This code loads in a few …

javascript merge append user-defined-functions prepend
Create a custom worksheet function in Excel VBA

I have a faint memory of being able to use VBA functions to calculate values in Excel, like this (as …

vba excel user-defined-functions
How is "=default" different from "{}" for default constructor and destructor?

I originally posted this as a question only about destructors, but now I'm adding consideration of the default constructor. Here's …

c++ c++11 user-defined-functions default-constructor deleted-functions
What's a good way to check if two datetimes are on the same calendar day in TSQL?

Here is the issue I am having: I have a large query that needs to compare datetimes in the where …

sql sql-server tsql datetime user-defined-functions