一个查询代码为了记忆

SELECT (cast(T0.Quantity  * 0.002 as char) as 数量) as
FROM ITT1 T0
WHERE T0.Code =[%0]

 

 

就是为了解决字段直接乖一个小数时返回为完整数，而不是0.00.

 

以下是又一个代码。

 

if $[opdn.u_rklx]='b'

   select '110'

else

   SELECT  case when T0.DfltWH is not null then t0.dfltwh

               when t0.dfltwh is null then '100'

                end

          FROM OITM T0  WHERE T0.ItemCode =$[$38.1.0]

 

if $[opdn.u_rklx]='b'

   select '110'

else

   SELECT  case when T0.DfltWH is not null then t0.dfltwh

               when t0.dfltwh is null then '100'

                end

          FROM OITM T0  WHERE T0.ItemCode =$[$38.1.0]