UDF into variable

  • hi

    i am executing udf as (select fGetGenericDate (@param)) which returns datetime as datatypeof values.

    ho wto get this values in local variable

  • Pseudocode:

    declare @var datatype;

    select @var = function(@param) -- for scalar

    select @var = col from schema.function(@param) -- for table valued

    For table valued functions, note that @var will contain the first value returned in the result set from the function.



    Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

    Concatenating Row Values in Transact-SQL[/url]

  • thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply