Newer
Older
java_learning / stored / ensyu09.sql
himeno on 2 Aug 2019 240 bytes init
CREATE PROCEDURE multiple(@num1 INT, @num2 INT, @ans INT OUTPUT)
AS
BEGIN
	DECLARE @cnt INT;

	SET @ans = 0;
	SET @cnt = 0;

	WHILE @cnt < @num2
	BEGIN
		EXECUTE plus @ans, @num1, @ans OUTPUT;
		SET @cnt = @cnt + 1;
	END
END;