declare @a as float declare @b as int set @a = 12345.54321 set @b = 1100 select floor ( @a / @b ) -- floor是取整数 select @a - @b * floor ( @a / @b )