Sergio,

As Gary mentioned, you can return result sets from an sproc:

SELECT * FROM MyTable 
SELECT * FROM MyOtherTable 

The above will return two result sets from the sproc. Typically you will "capture" this info in a DataSet:

SqlCommand sc = new SqlCommand("MySqlProc", this.oConnection);
sc.CommandType = CommandType.StoredProcedure;

SqlDataAdapter da = new SqlDataAdapter(sc);

// Fill the DataSet
DataSet ds = new DataSet();
da.Fill(ds);

The above will create 2 DataTables in the DataSet, since the sproc returns 2 result sets.

~~Bonnie




>What are the different type of data that a store procedure can return?
>I ussually return a single value, but can I return for example an array or any other type of data?.
>
>
>Thanks