How to return an array of IDs from stored procedure?

Question

I have a stored procedure that should return an array of ids, depending on the result of a SELECT query. How can I do this in SQL Server?

Here is my stored procedure:

ALTER PROCEDURE [dbo].[PS_testGar] 
    @CODE_B,
    @ids OUTPUT
AS 
BEGIN  
   SELECT @ids = code_gar
   FROM  [dbo].[GARANTIE]
   WHERE CODE_B= @CODE_B
END 

Answer 1

No need for an output parameter here. This is what your procedure should look like.

ALTER PROCEDURE [dbo].[PS_testGar] 
(
    @CODE_B int --or whatever your datatype is
) AS  
BEGIN  
    SET NOCOUNT ON;

    SELECT code_gar
    FROM  [dbo].[GARANTIE]
    WHERE CODE_B = @CODE_B
END