Post reply

SET ROWCOUNT and TVF

  • December 14, 2005 at 5:21 pm

    #166453

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

  • December 21, 2005 at 12:10 pm

    #610924

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

    Cheers,

    david russell

  • December 21, 2005 at 8:20 pm

    #611009

    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!

  • March 10, 2008 at 10:15 am

    #787469

    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?

    😉

Viewing 4 posts - 1 through 3 (of 3 total)

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