SQLServerCentral / Discuss Content Posted by Peter He / Article Discussions / Article Discussions by Author / SET ROWCOUNT and TVF / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 17:21:21 GMT20RE: SET ROWCOUNT and TVFhttp://www.sqlservercentral.com/Forums/Topic244324-262-1.aspxI 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?;-)Mon, 10 Mar 2008 10:15:25 GMTbaldeRE: SET ROWCOUNT and TVFhttp://www.sqlservercentral.com/Forums/Topic244324-262-1.aspxWell 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! <img src='images/emotions/smile.gif' height='20' width='20' border='0' title='Smile' align='absmiddle'>Wed, 21 Dec 2005 20:20:00 GMTIan YatesRE: SET ROWCOUNT and TVFhttp://www.sqlservercentral.com/Forums/Topic244324-262-1.aspxvery nice use of graphics. good subject. I am sure it will be useful at some point. Thanks!Wed, 21 Dec 2005 12:10:00 GMTdavid russell-253790SET ROWCOUNT and TVFhttp://www.sqlservercentral.com/Forums/Topic244324-262-1.aspxComments posted to this topic are about the content posted at <A HREF="http://www.sqlservercentral.com/columnists/phe/setrowcountandtvf.asp">http://www.sqlservercentral.com/columnists/phe/setrowcountandtvf.asp</A>Wed, 14 Dec 2005 17:21:00 GMTpeterhe