SET Functions

  • Comments posted to this topic are about the item SET Functions

  • The question is a bit ambiguous

  • Good one.

    Jamie

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

  • 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 asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • 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 🙂

  • Good question...:)

  • 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.

  • 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 8 (of 8 total)

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