Tuesday, February 21, 2012

Returning more than one Record from SP...

Hi ,
Is there a way in SQL Server stored procedure to return multiple records/ more than one records...?
Thanks in Advance...
-Mohit.Do you mean as output to another stored procedure? (Of course they can return more than one record...)

Consider using a User-defined table function. These can return datasets that can be directly joined in sql statements as if they were actual tables.

No comments:

Post a Comment