New posts in Sqlncli

Need a row count after SELECT statement: what's the optimal SQL approach?