22,207
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE #TA
(
ID varchar(20)
)
INSERT INTO #TA
select '1'
UNION SELECT '2'
UNION SELECT 'AA'
select sum( cast(ID as int) )
from TA
select sum(Case when ISNUMERIC([ID]) =1 then [ID] ELSE 0 END )
from #TA
select sum( cast(isnumeric(ID) as int) )
from TA