Top "User-defined-functions" questions

How to add builtin functions?

I am new to python programming. How can I add new built-in functions and keywords to python interpreter using C …

python user-defined-functions keyword built-in

Excel is calculating a formula with a VBA function as an error unless it is re-entered

I've got a simple if statement set up in a worksheet where the if condition is VBA user defined function: …

excel vba user-defined-functions

SqlFunction fails to open context connection despite DataAccessKind.Read present

I've got a SqlServer project with a very simple test for a Table-Valued-Function:- [SqlFunction(TableDefinition = "forename nvarchar(50)", FillRowMethodName = "TestFillRow", …

c# .net sql-server sqlclr user-defined-functions

Cannot create index on view with User Defined Function in SQL Server

In SQL Server 2005, I'm trying to use a User Defined Function in a indexed view that will be used in …

sql-server indexing views user-defined-functions

How to pass a constant value to Python UDF?

I was thinking if it was possible to create an UDF that receives two arguments a Column and another variable (…

python apache-spark pyspark apache-spark-sql user-defined-functions

MySQL does not support recursive functions? why? since when?

I've written a stored FUNCTION that calls itself, recursively. However when I run it in a query I get this …

mysql stored-procedures recursion user-defined-functions stored-functions

Why is my custom MySQL function so much slower than inlining same in query?

I repeatedly use this SELECT query to read unsigned integers representing IPv4 addresses and present them as human readable dotted …

mysql performance user-defined-functions

CLR Table-valued function with array argument

I have a SQL CLR function like this one: public partial class UserDefinedFunctions { [Microsoft.SqlServer.Server.SqlFunction(TableDefinition = "number int", …

sql-server user-defined-functions sqlclr table-valued-parameters

MySQL - Trouble with creating user defined function (UDF)

I'm trying to create this function: CREATE FUNCTION remove_non_alphanum (prm_strInput varchar(3000)) RETURNS VARCHAR(3000) DETERMINISTIC BEGIN DECLARE i …

mysql mysql-error-1064 user-defined-functions dbvisualizer

User defined function to be applied to Window in PySpark?

I am trying to apply a user defined function to Window in PySpark. I have read that UDAF might be …

apache-spark pyspark aggregate-functions user-defined-functions window-functions