[Microsoft][ODBC SQL Server Driver][SQL Server]将varchar值'一等船长'转换为数据类型为int的列时发生语法错误。

[BlueskyWide]

在insert此表时，发生错误如题。
本人在此表上建立一个trigger。发生错误的该字段名为apply_name,定义为varchar(14),但为什么odbc要将其转换为数据类型呢？！

请高手指点，谢谢！

[welyngj]

可能隐式转换。最好贴出源代码。

[BlueskyWide]

trigger为：

use wjgj_exam
go
create trigger lj_instead_code on lj_examlogin for insert
as
if (select s.apply_name from subject_apply s join inserted i
on s.apply_name=i.apply_name
and s.exam_type=i.exam_type )>0
begin
update j set j.type_detail=(select s.type_detail from subject_apply s inner join inserted i
on s.apply_name=i.apply_name and s.exam_type=i.exam_type)
from lj_examlogin j inner join inserted i on j.apply_name=i.apply_name and j.exam_type=i.exam_type
end

用到的表及字段为：
lj_examlogin表：
apply_name varchar(14) not null,
exam_type varchar(1) not null,
type_detail varchar(4),
subject_apply表：
type_detail varchar(4) not null,
apply_name varchar(14) not null,
exam_type varchar(1) not null,

[Jianli2004]

if (select s.apply_name from subject_apply s join inserted i
on s.apply_name=i.apply_name
and s.exam_type=i.exam_type )>0 ---选出是字符型不能>0

if exists (select s.apply_name from subject_apply s join inserted i
on s.apply_name=i.apply_name
and s.exam_type=i.exam_type )

or

if len(select s.apply_name from subject_apply s join inserted i
on s.apply_name=i.apply_name
and s.exam_type=i.exam_type )>0

[Jianli2004]

if (select s.apply_name from subject_apply s join inserted i
on s.apply_name=i.apply_name
and s.exam_type=i.exam_type )>0 ---选出是字符型不能>0

if exists (select s.apply_name from subject_apply s join inserted i
on s.apply_name=i.apply_name
and s.exam_type=i.exam_type )

or

if len(select s.apply_name from subject_apply s join inserted i
on s.apply_name=i.apply_name
and s.exam_type=i.exam_type )>0

[BlueskyWide]

谢谢两位！