似乎isnumeric有一些问题:
http://www.sqlhacks.com/Retrieve/Isnumeric- problems (通过Internet存档)
select
cast(Reserve as decimal)
from MyReserves
where MyReserves is not null
and MyReserves * 1 = MyReserves
SQL IsNumeric无法正常工作
似乎isnumeric有一些问题:
http://www.sqlhacks.com/Retrieve/Isnumeric- problems (通过Internet存档)
select
cast(Reserve as decimal)
from MyReserves
where MyReserves is not null
and MyReserves * 1 = MyReserves