11,849
社区成员
发帖
与我相关
我的任务
分享
--> 测试数据:[A1]
if object_id('[A1]') is not null drop table [A1]
create table [A1]([单号欠款] varchar(4),[C2] numeric(6,2))
insert [A1]
select '12-2',0.00 union all
select '12-3',3000.00
select * from [A1]
select * from A1 where [C2]>cast(0 as decimal(18,2))
/*
单号欠款 C2
---- ---------------------------------------
12-3 3000.00
(1 行受影响)
*/