user-defined-functions
VBA Excel UDF retaining original value
I have a UDF non-volatile function in VBA, which requires a global variable (callback to VSTO) initialized.[详细]
2023-03-09 13:09 分类:问答TSQL UDF To Split String Every 8 Characters
Someone decided to stuff a bunch of times together into a single column, so the column value might look like this:[详细]
2023-03-07 21:58 分类:问答Aggregate result of table valued UDF
I have a table valued UDF (it returns a number of rows). How can I aggregate the table valued results in a SQL query?[详细]
2023-03-07 06:16 分类:问答How to create SQL Operators Combination like ALL IN, NOT ALL IN
I have below 4 properties in a Filter class. I am going to parse below 4 properties to a StoredProcedure and get the filtered result.[详细]
2023-03-06 15:16 分类:问答Dynamically buiding an XPath query string
I have a chained XSLT 2.0 transformation scenario (using saxon), like this: - I1.xml is input for T1.xslt, stylesheet which will build T2.xslt[详细]
2023-03-06 08:47 分类:问答SQL Server view or table-valued function? [duplicate]
This question already has answers here: reuse sql with view or function (4 answers) Closed 9 years ago. Anyone have a good decisioning tree for deciding when to use a view and when to use[详细]
2023-03-06 04:55 分类:问答Can I delete rows using user defined functions in oracle?
I created a user defined function to delete some data. It doesn\'t work with delete but works with select. I am Oracle 9i.[详细]
2023-03-05 16:02 分类:问答SQL Server 2008 T-SQL UDF Split() Tailoring
I\'m useing SQL Ser 2008 and have a large table with only one column of data. The data is a random string with very little consistency. Eample: Name Account 445566 0010020056893010445478008 AFD 369. I[详细]
2023-03-05 00:29 分类:问答Creating a UDF for MySQL in Delphi
How do I create a UDF for MySQL using Delphi? Does anyone have any code templates? I want the code template to be integrated in Delphi versions(2007 and upper), so I need these templates to be usabl[详细]
2023-03-02 19:10 分类:问答TSQL - Count specific values within Multistatement table UDF and pass them to additional column
during coding my project I have encountered an obstacle and cannot go through with this issue... here is what I would like to achieve, I have a simple table which stores data connected with football[详细]
2023-03-01 17:55 分类:问答