CREATE PROCEDURE TRANSFORM (@in1 int,
@in2 varchar(50),
@out1 int OUTPUT,
@out2 varchar(60) OUTPUT)
AS SELECT
@out1 = 2 * @in1,
@out2 = 'Hello, ' + @in2;