SQL Server and TSQL do not have an array data structure. You can return a result set by just doing a SELECT:
USE pubs
GO
CREATE PROCEDURE getAuthors
AS
SELECT * FROM authors
You can also return multiple values using XML. Refer to the BOL for more info, specifically the FOR XML clause.
-Mike
>Hi,
>
>If it possible with an SP to return an array, recordser or a cursor ?
>
>Thank in advance.
>
>Dave
>Technologies Nter