BUG: 7.0 ISQL.EXE Returns Different Results than 6.5 ISQL.EXE (234890)

SYMPTOMS

Running the following stored procedure created in the pubs database against SQL Server version 7.0:

CREATE PROCEDURE dbo.my_proc
  AS  BEGIN
     SET NOCOUNT ON
     SELECT '000', '1','2','3','4','5','6','7','8','9','0'
     SELECT '010', '1','2','3','4','5','6','7','8','9','0'
     SELECT '020', '1','2','3','4','5','6','7','8','9','0'
  END
				

using the following command line:

   isql /Usa /P /dpubs /h-1 /s /Q"exec my_proc" /ooutput.txt
				

returns the following results in the Output.txt file when using Isql.exe from SQL Server version 6.5:

   0001234567890

   0101234567890

   0201234567890
				

When run using Isql.exe from SQL Server version 7.0 or SQL Server 2000, Output.txt contains:

   0001234567890
   010
   1234567890
   020
   1234567890