SQL：如何用例并强制转换查询？
|
我想将VARCHAR转换为INT，但是在我的表中我有一些值，例如\'??? \'，然后SQL Server启动此Expcetion：
Conversion failed when converting the varchar value \'????\' to data type int.
Severity 16
INSERT INTO labbd11..movie(title, year)
SELECT movies.title,
CASE movies.mvyear IS \'????\' THEN NULL ELSE CAST (movies.mvyear AS INT)
FROM disciplinabd..movies
没有找到相关结果
已邀请:
5 个回复
抵舵
INSERT INTO labbd11..movie(title, year) SELECT movies.title, CASE WHEN IsNumeric(movies.mvyear+ \'.0e0\') <> 1 THEN NULL ELSE CAST (movies.mvyear AS INT) END FROM disciplinabd..movies晤默报
INSERT INTO labbd11..movie(title, year) SELECT movies.title, CAST( CASE movies.mvyear WHEN \'????\' THEN NULL ELSE movies.mvyear END AS INT) FROM disciplinabd..movies悸翠疮武昏
INSERT INTO labbd11..movie(title, year) SELECT movies.title, CASE WHEN movies.mvyear = \'????\' THEN NULL ELSE CAST (movies.mvyear AS INT) END FROM disciplinabd..movies泪琉踞檄
INSERT INTO labbd11..movie(title, year) SELECT movies.title, CAST(CASE WHEN movies.mvyear = \'????\' THEN NULL ELSE movies.mvyear END AS INT) FROM disciplinabd..movies娜拐赐巫潭