hello people

I was wondering if there is the equivalent of oracle ref cursor in MSSQL
I need it because, in oracle if i need to return multiple table within the same stored procedure, all i have to do is pass back multiple ref cursors as output parameters. How can i achieve the same thing in MSSQL?

Cheers
James