摘要:
把字符串数字转换成浮点数select case when ISNUMERIC(@guige) = 1 then cast(@guige as decimal(18,2)) else 0 end 阅读全文
posted @ 2013-06-14 15:28 ╰★张志峰★╮ 阅读(287) 评论(0) 推荐(0)
|
||
|
摘要:
把字符串数字转换成浮点数select case when ISNUMERIC(@guige) = 1 then cast(@guige as decimal(18,2)) else 0 end 阅读全文
posted @ 2013-06-14 15:28 ╰★张志峰★╮ 阅读(287) 评论(0) 推荐(0) |
||