34,838
社区成员




declare @tb table (name varchar(10))
insert into @tb select null
insert into @tb select '123'
insert into @tb select 'a1'
select * from @tb
where isnumeric(name)=0
NULL
a1
declare @tb table (name varchar(10))
insert into @tb select null
insert into @tb select '123'
insert into @tb select 'a1'
select cast(name as decimal(18,2)) from @tb
select cast(大字段 as int)-cast(小字段 as int) from temp1
select cast(大字段 as decimal(18,2))-cast(小字段 as decimal(18,2)) from temp1