Skip to main content
A
Anonymous
March 31, 2009
Question

Database Functions

  • March 31, 2009
  • 1 reply
  • 484 views
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!
    This topic has been closed for replies.

    1 reply

    D
    Dan_Bracuk
    Inspiring
    March 31, 2009
    The term database function is ambiguous.
    A
    Anonymous
    March 31, 2009
    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
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices