Simple SP to return multiple results

CREATE PROCEDURE db_abbTest
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Insert statements for procedure here
    SELECT 1
    SELECT 2
    SELECT 3
    RETURN 0
END
GO