• I don't tend to use them with .NET but do like using output parameters when having stored procedures run another (sub) stored procedure type module and a large record set is not required.

    Basically, in a way similar to creating / running a UDF but without the performance issues.

    UDF's of course are functionally simpler to code with and use... but its just not worth it.