SET ROWCOUNT and TVF

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

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


    Cheers,

    david russell

  • 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!

  • 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