SET Functions

Question

Post reply

SET Functions

karthik.nallajalla

SSC Enthusiast

Points: 140
More actions
February 5, 2009 at 8:56 pm

#218246

Comments posted to this topic are about the item SET Functions

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

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

arup chakraborty Hall of Fame Points: 3640 More actions · Answer 1

arup chakraborty

Hall of Fame

Points: 3640

February 6, 2009 at 2:00 am

#939343

The question is a bit ambiguous

Jamie-2229 SSCrazy Eights Points: 8156 More actions · Answer 2

Jamie-2229

SSCrazy Eights

Points: 8156

February 6, 2009 at 5:24 am

#939396

Good one.

Jamie

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

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

webrunner SSC-Dedicated Points: 31715 More actions · Answer 4

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

Tim Wilson-Brown Ten Centuries Points: 1395 More actions · Answer 5

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 More actions · Answer 6

Anipaul

SSC-Insane

Points: 24681

February 11, 2009 at 4:47 am

#941996

Good question...:)

gyanp.garg SSC Veteran Points: 274 More actions · Answer 7

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 More actions · Answer 8

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.