How to do Stored Procedure return multiple rows?

[jarnail]

Hi,

I want to fetch multiple rows by Stored Procedure. Can anybody plz help me? It can be just like “Select * from employee”.

Thanks in advance.