CREATE PROCEDURE sp_without_set_nocount (
  IN bigintIn BIGINT,
  OUT bigintOut BIGINT,
  OUT binaryOut BINARY(50),
  OUT bitOut BIT(1),
  OUT charOut CHAR(10),
  OUT dateOut DATE,
  OUT datetimeOut DATETIME,
  OUT decimalOut DECIMAL(10, 2),
  OUT floatOut FLOAT(53),
  OUT intOut INT,
  OUT ncharOut NCHAR(10),
  OUT numericOut NUMERIC(10, 2),
  OUT nvarcharOut NVARCHAR(50),
  OUT realOut REAL,
  OUT smallintOut SMALLINT,
  OUT textOut TEXT,
  OUT timeOut TIME,
  OUT tinyintOut TINYINT,
  OUT varbinaryOut VARBINARY(50),
  OUT varcharOut VARCHAR(50)
)
BEGIN
  INSERT INTO tmp_pq_test_table (bigintCol, intCol, nvarcharCol) VALUES (10, 10, 'ten');

  SELECT intCol, nvarcharCol FROM tmp_pq_test_table ORDER BY intCol ASC;

  INSERT INTO tmp_pq_test_table (bigintCol, intCol, nvarcharCol) VALUES (99, 99, 'ninety nine');

  SELECT bigintCol, nvarcharCol FROM tmp_pq_test_table ORDER BY bigintCol ASC;
  
  SELECT
   bigintCol,
   binaryCol,
   bitCol,
   charCol,
   dateCol,
   datetimeCol,
   decimalCol,
   floatCol,
   intCol,
   ncharCol,
   numericCol,
   nvarcharCol,
   ROUND(realCol, 2),
   smallintCol,
   textCol,
   timeCol,
   tinyintCol,
   varbinaryCol,
   varcharCol
  INTO
   bigintOut,
   binaryOut,
   bitOut,
   charOut,
   dateOut,
   datetimeOut,
   decimalOut,
   floatOut,
   intOut,
   ncharOut,
   numericOut,
   nvarcharOut,
   realOut,
   smallintOut,
   textOut,
   timeOut,
   tinyintOut,
   varbinaryOut,
   varcharOut
  FROM tmp_pq_test_table
  WHERE bigintCol = bigintIn;
END