Post reply

UDF into variable

  • April 13, 2012 at 2:11 pm

    #254824

    hi

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

    ho wto get this values in local variable

  • April 13, 2012 at 2:20 pm

    #1473500

    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]

  • April 13, 2012 at 2:29 pm

    #1473507

    thanks

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

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