0
Database Functions
Explorer
,
/t5/coldfusion-discussions/database-functions/td-p/799776
Mar 31, 2009
Mar 31, 2009
Copy link to clipboard
Copied
Hey all, I can't say I've ever had to use a stored database
function. Does anyone know if there is some documentation or
examples for using functions instead of stored procedures - or can
I use a function the same way I would use a stored procedure?
Thanks!
Thanks!
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
LEGEND
,
/t5/coldfusion-discussions/database-functions/m-p/799777#M74201
Mar 31, 2009
Mar 31, 2009
Copy link to clipboard
Copied
The term database function is ambiguous.
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
CF_output
AUTHOR
Explorer
,
LATEST
/t5/coldfusion-discussions/database-functions/m-p/799778#M74202
Mar 31, 2009
Mar 31, 2009
Copy link to clipboard
Copied
In MS SQL, its under a database --> Programmability -->
Functions --> Scalar-valued Functions.
I believe I found the solution, I can access the function via cfquery instead of cfstoredproc.
Example:
SELECT test, dbo.function_test(param1,param2) as myTest
FROM TestTable
WHERE test = 1
I believe I found the solution, I can access the function via cfquery instead of cfstoredproc.
Example:
SELECT test, dbo.function_test(param1,param2) as myTest
FROM TestTable
WHERE test = 1
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more

