SET ROWCOUNT and TVF

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 Peter He » SET ROWCOUNT and TVF

SET ROWCOUNT and TVF

Rate Topic

Display Mode

Topic Options

Author

Message

peterhe

Posted Wednesday, December 14, 2005 5:21 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 10:51 AM
Points: 531, Visits: 416

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/phe/setrowcountandtvf.asp

Post #244324

david russell-253790

Posted Wednesday, December 21, 2005 12:10 PM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 22, 2006 2:23 PM
Points: 254, Visits: 1

very nice use of graphics. good subject. I am sure it will be useful at some point. Thanks!

Cheers,

david russell

Post #245943

Ian Yates

Posted Wednesday, December 21, 2005 8:20 PM

Ten Centuries

Group: General Forum Members
Last Login: Sunday, September 16, 2012 3:26 AM
Points: 1,038, Visits: 443

Well caught with the UDF hole. That's the sort of thing you could overlook and wonder why a select statement is returning garbage results.. Thanks!

Post #246053

balde

Posted Monday, March 10, 2008 10:15 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 4:11 AM
Points: 135, Visits: 227

I would question the reliability of the SET ROWCOUNT @n...

.. unless of course it's a problem with SELECT TOP n, i've just tried both methods with the exact same query and each method returned a different result-set.

Does anyone know of any inherent differences in the 2 methods that we should all be aware of?

Wink

Post #466797

« Prev Topic | Next Topic »

Permissions