February 5, 2009 at 8:56 pm
Comments posted to this topic are about the item SET Functions
February 6, 2009 at 2:00 am
The question is a bit ambiguous
February 6, 2009 at 5:24 am
Good one.
Jamie
February 6, 2009 at 6:25 am
Actually, it seemed quite obvious to me and have never used the option personally.
February 6, 2009 at 7:44 am
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
February 8, 2009 at 9:37 pm
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 🙂
February 11, 2009 at 4:47 am
Good question...:)
February 23, 2009 at 10:07 pm
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.
February 25, 2009 at 8:08 pm
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