document.write('CREATE PROCEDURE [InOutExample]
');
document.write('
');
document.write('@Number INT,
');
document.write('@Text NVARCHAR(50) AS
');
document.write('
');
document.write('SELECT @Number = @Number + 1
');
document.write('SELECT @Text = UPPER(@Text)');