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

问题描述

我收到错误将varchar值'Id'转换为数据类型int时转换失败....



我尝试了什么：

I got an error "Conversion failed when converting the varchar value 'Id' to data type int"....

What I have tried:

SELECT *
FROM History
INNER JOIN Header
ON History.Id = Header.docId

推荐答案

 declare @History table (Id varchar(50),Name varchar(50))
declare @Header table (docId int,Name varchar(50))
insert into @History(id,name)values( 'id', 'a')
insert into @History(id,name)values( '2', 'a')

insert into @Header(docId,name)values( '2', 'a1')
insert into @Header(docId,name)values( '2', 'b1')


 select * from (  (SELECT * FROM @History where ISNUMERIC(id) =1 ) hi   INNER JOIN @Header he ON  hi.id = he.docId )

使用 []检查值是否为有效数字

use ISNUMERIC (Transact-SQL)[^] to check the value is a valid number or not

这篇关于将varchar值'id'转换为数据类型int时转换失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！