Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SET ROWCOUNT and TVF Expand / Collapse
Author
Message
Posted Wednesday, December 14, 2005 5:21 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Saturday, May 3, 2014 6:30 PM
Points: 531, Visits: 430
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/phe/setrowcountandtvf.asp


Post #244324
Posted Wednesday, December 21, 2005 12:10 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC 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
Posted Wednesday, December 21, 2005 8:20 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 30, 2014 10:08 PM
Points: 1,038, Visits: 444
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
Posted Monday, March 10, 2008 10:15 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 9:07 AM
Points: 294, Visits: 394
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?




Post #466797
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse