SET Functions

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Karthik Nallajalla » SET Functions

SET Functions

Rate Topic

Display Mode

Topic Options

Author

Message

karthik.nallajalla

Posted Thursday, February 05, 2009 8:56 PM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, October 06, 2009 1:58 PM
Points: 84, Visits: 32

Comments posted to this topic are about the item SET Functions

Post #651388

arup chakraborty

Posted Friday, February 06, 2009 2:00 AM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, July 03, 2012 5:49 AM
Points: 418, Visits: 365

The question is a bit ambiguous

Post #651450

Jamie Longstreet-481950

Posted Friday, February 06, 2009 5:24 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 6:57 PM
Points: 2,440, Visits: 712

Good one.

Jamie

Post #651527

Lynn Pettis

Posted Friday, February 06, 2009 6:25 AM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 3:18 AM
Points: 21,588, Visits: 27,375

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

Cool

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #651556

webrunner

Posted Friday, February 06, 2009 7:44 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 3:05 PM
Points: 2,117, Visits: 2,209

Good question (though I got it wrong Sad

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

-------------------
"The chemistry must be respected." - Walter White

"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

Post #651670

Tim Wilson-Brown

Posted Sunday, February 08, 2009 9:37 PM

SSC Veteran

Group: General Forum Members
Last Login: Sunday, August 19, 2012 6:40 PM
Points: 202, Visits: 301

webrunner (2/6/2009)

Good question (though I got it wrong Sad

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

Post #652534

Anipaul

Posted Wednesday, February 11, 2009 4:47 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 2:50 AM
Points: 4,785, Visits: 1,334

Good question...:)

Post #654651

gyanp.garg

Posted Monday, February 23, 2009 10:07 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 25, 2012 4:03 AM
Points: 185, Visits: 52

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.

Post #663208

Tim Wilson-Brown

Posted Wednesday, February 25, 2009 8:08 PM

SSC Veteran

Group: General Forum Members
Last Login: Sunday, August 19, 2012 6:40 PM
Points: 202, Visits: 301

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.

Post #664734

« Prev Topic | Next Topic »

Permissions