declare @t table(id int,num decimal(18,2))
insert @t values(1,0.5)
insert @t values(1,1.5)
insert @t values(1,1.15)select *,convert(float,num) from @t
insert @t values(1,0.5)
insert @t values(1,1.5)
insert @t values(1,1.15)select *,convert(float,num) from @t
select @a
select convert(real,@a)
在数据提取出来,显示在DBGridEh时,格式话显示格式0.00