SET ROWCOUNT and TVF

  • peterhe

    SSChampion

    Points: 11362

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

  • david russell-253790

    SSCarpal Tunnel

    Points: 4042

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


    Cheers,

    david russell

  • Ian Yates

    SSCoach

    Points: 19738

    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!

  • balde

    SSCommitted

    Points: 1594

    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 4 (of 4 total)

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