user-defined-functions
my_udf_init not called
This is my first time trying to create an udf for mysql. The docs state that my_func_init gets called prior to executing the main function, yet in my environment this does not seem to happen.[详细]
2023-04-04 02:06 分类:问答convert string to datetime in function SQL Server
I have been writing a user-defined function in SQL Server: It looks like this : CREATE FUNCTION FormatDate(@fromtime nvarchar(50))[详细]
2023-04-04 00:53 分类:问答ColdFusion User Defined Functions from included file aren't available
I am using ColdFusion 9. I am including a UDF library (UDF_Library.cfm) that has just a few functions it in.When I try to access the functions, I get an error that says \"Variable POPUP is undefined\[详细]
2023-04-03 13:24 分类:问答Why Hive errors FileNotFoundException when a UDF use some external resource files but runs right at native?
A 开发者_高级运维UDF used some external resource files, then it error: \"java.io.FileNotFoundException: resource/placeMap.txt (No such file or directory)\",[详细]
2023-04-03 09:39 分类:问答DB2 Query Structure Using User-Defined Function as a Table
I\'m a little new to DB2, and am having trouble developing a query. I have created a user-defined function that returns a table of data which I want to then join and select from in larger select state[详细]
2023-04-01 03:34 分类:问答Searching by distance in SQL
I am planning a website (Drupal/MySQL), which must search a fairly large database based on distance from a location (we\'re starting with ~20,000 locat开发者_运维百科ions). So far, the best solution I[详细]
2023-03-31 22:26 分类:问答How can I improve the performance of Excel UDF that call web services?
We are dev开发者_Python百科eloping a kind of stock lookup UDF in c# for Excel. Our UDF ends up calling a web service, which can be very slow if a sheet has, say 1000 calls to our web service.[详细]
2023-03-31 20:14 分类:问答Add delimiter to concatenated list
I found this custom Excel Function: Function Join(source As Range, Optional delimiter As String) As String[详细]
2023-03-31 08:45 分类:问答guarantee order of table valued function results
PREMISE: The application code cannot be changed. The conditions are very specific. I am looking for something off the books, a last resort workaround if you may.[详细]
2023-03-28 22:59 分类:问答Is it a good practice to create a stored procedure that creates a user-defined function...?
I\'m analyzing a fellow developer\'s SQL code and I could be totally wrong, but something they\'ve done doesn\'t seem good to me.[详细]
2023-03-28 07:34 分类:问答