select t,a,a*0.3 as b from table v
如果0.3是变量,[email protected] 代替,该如何写啊?
------解决方案--------------------
declare @i decimal(4,1)
set @i = 0.3
select t,a,[email protected] as b from table v
------解决方案--------------------
楼上正解,接个小分
------解决方案--------------------
不重复了,接分
------解决方案--------------------
來晚了