将varchar值'none'转换为数据类型int时转换失败

如果您的表实际上由None和NA组成，请尝试以下操作：

ALTER PROCEDURE spvecASSELECt Row_number() OVER (ORDER BY (SELECT 1)) AS 'RNumber'    ,vf.*FROM LOGIN ld    ,vehicle vfWHERe (ld.fid = cast(vf.fid as varchar(max)))    AND cast(ld.id as varchar(2)) <> 'NA'    AND cast(vf.CustID as varchar(4)) <> 'None'    AND cast(vf.Simo as varchar(4)) <> 'None'ORDER BY Row_number() OVER (ORDER BY (SELECT 1))