SET ROWCOUNT and TVF

Question

Post reply

SET ROWCOUNT and TVF

peterhe

SSChampion

Points: 11469
More actions
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

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

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

david russell-253790 SSCarpal Tunnel Points: 4042 More actions · Answer 1

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 More actions · Answer 2

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 More actions · Answer 3

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?

SET ROWCOUNT and TVF

Cookies on SQLServerCentral