SET Functions

  • karthik.nallajalla

    SSC Enthusiast

    Points: 140

    Comments posted to this topic are about the item SET Functions

  • arup chakraborty

    Hall of Fame

    Points: 3640

    The question is a bit ambiguous

  • Jamie-2229

    SSCrazy Eights

    Points: 8151

    Good one.

    Jamie

  • Lynn Pettis

    SSC Guru

    Points: 442098

    Actually, it seemed quite obvious to me and have never used the option personally.

  • webrunner

    One Orange Chip

    Points: 29803

    Good question (though I got it wrong :(). The only quibble I have with the formatting is the use of the term "function(s)" in the question.

    The "(s)" doesn't make sense in that context, since only 1 function choice is possible with radio buttons.

    Thanks,

    webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and says Can I join you?
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • Tim Wilson-Brown

    Ten Centuries

    Points: 1395

    webrunner (2/6/2009)


    Good question (though I got it wrong :(). The only quibble I have with the formatting is the use of the term "function(s)" in the question.

    The "(s)" doesn't make sense in that context, since only 1 function choice is possible with radio buttons.

    Also, SET FMTONLY is a 'setting' not a 'function' - for those who like their terminology 🙂

  • Anipaul

    SSC-Insane

    Points: 24681

    Good question...:)

  • gyanp.garg

    SSC Veteran

    Points: 274

    I think FMTONLY Executes query. as i came to know from earlier comments, FMTONLY returns meta data without processing any row how can it estimate the query response. please clear my doubts.

  • Tim Wilson-Brown

    Ten Centuries

    Points: 1395

    SET FMTONLY generates metadata using the structure of the query - metadata can be derived from the types of constants, columns, or expressions.

    In the case of stored procedures, which aren't typed, SET FMTONLY needs to execute the SP in order to determine the metadata. This may also be true for inline table-valued functions - but I'm not sure.

    If you need more information, check out SQL Server books online at http://msdn.microsoft.com/en-us/library/ms173839.aspx or post a question in the general T-SQL forums.

Viewing 9 posts - 1 through 9 (of 9 total)

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