user-defined-functions
Passing select statement as parameter to scalar function in SQL
I have scalar function which takes an integer as argument and return an integer too. I was trying t开发者_如何学Pythono use this function by passing a parameter as a select statement which looks like[详细]
2023-04-12 13:55 分类:问答how to make a UDF in sql for determining month of year?
I want to make a user defined function for calculating the month number from date. But the problem is that I have the months numbered as 1, 2, 3 ... and each month is of 26 days, that makes a total o[详细]
2023-04-12 12:31 分类:问答T-SQL - CROSS APPLY to a PIVOT? (using pivot with a table-valued function)?
I have a table-valued function, basically a split-type function, that returns up to 4 rows per string of data.[详细]
2023-04-09 14:39 分类:问答Load Multiple Functions from a Single File in Matlab [duplicate]
This question already has answers here: Closed 11 years ago. Possible Duplicate: Is it possible to define more than one function per file in MATLAB?[详细]
2023-04-08 05:52 分类:问答Implementing some cryptography algorithms on sql server
Can we write 开发者_运维问答a user defined function to encrypt a string of text based on a key in sql server 2000? For e.g. I want to try writing a triple DES algorithm to encrypt text. How to write s[详细]
2023-04-07 18:32 分类:问答Use of function calls in stored procedure sql server 2005?
Use of function calls in where clause of stored procedure slows down performance in sql server 2005? SELECT * FROM Member M[详细]
2023-04-07 01:18 分类:问答What wrong with this php user defined function?
I cant find that what i have missed in this function so its generating this ERROR some time not always ?[详细]
2023-04-06 21:42 分类:问答How to get the cell value from another worksheet and assign it to the return value of UDF?
Here is the little example of my two worksheets. Original Sheet: As you can see, this worksheet has two cells waiting to be recalculated at the later stage. (i.e. cells with red #Eval marker)[详细]
2023-04-06 20:58 分类:问答What is the best way of including a UDF/CFC in a ColdFusion Model-Glue controller?
I have some common UDFs and CFCs that I\'d like to make available to all my controllers. I\'m using Model-Glue 3. I\'ve thought of several ways of doing so:[详细]
2023-04-06 05:40 分类:问答ColdFusion - What is the best way to replace values to format a paragraph?
I am using ColdFusion 9. I am outputting a chunk of text from a database to be directly into a web page. I don\'t want users to have to write HTML and screw things up. So, I am having them insert a d[详细]
2023-04-04 02:53 分类:问答