Post reply

User Defined Functions

  • October 29, 2003 at 6:47 am

    #101733

    Are user defined function precompiled and stored in cache like stored procedures?

  • October 29, 2003 at 1:38 pm

    #480178

    While SQL Server documentation does not address if UDFs are precompiled and stored, you may notice there is a WITH RECOMPILE option that is available for UDFs. It is only logical to assume that if this option exists, then UDFs can be precompiled.

  • October 29, 2003 at 11:01 pm

    #480235

    thanks pmbrown for the reply

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

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