I've been using SET ROWCOUNT to limit result sets, but I don't see how you can use it to return no data since SET ROWCOUNT 0 returns all rows.

>>RVs do this with a SET ROWCOUNT call to the SQL Server<<

>What is the equivalent in SQL-server SQL pass-through of NODATA ? I.e how can I force an empty cursor -- efficiently? (This must be a dumb question!)