DECLARE @ num1BIGINT, @ num2BIGINTSET @ num114SET @ num221DECLARE @ timesINTDECLARE @ minINTDECLARE @ resultBIGINTIF (@ num1 @ num2) SET @ min @ num2ELSESET @ min @ num1SET @ times @ minWHILE (@ times @ min) B
DECLARE @ num1 BIGINT, @ num2 bigint set @ num1 = 14 SET @ num2 = 21 DECLARE @ times int declare @ min int declare @ result bigint if (@ num1 = @ num2) SET @ min = @ num2 else set @ min = @ num1 SET @ times = @ min WHILE (@ times = @ min) B
Returns the maximum common number of two integers. <无>
DECLARE @num1 BIGINT, @num2 BIGINT SET @num1=14SET @num2=21 DECLARE @times INT DECLARE @min INT DECLARE @result BIGINT IF( @num1 >= @num2 ) SET @min=@num2 ELSE SET @min=@num1 SET @times=@min WHILE( @times <= @min ) BEGIN IF( @num1%@times = 0 AND @num2%@times = 0 ) BEGIN SET @result=@times BREAK END SET @times=@times - 1 END SELECT @result