关于swlserver去掉单引号

老师能问个问题吗，这两条sql是一样的，(266,267是上面)sql的子查询结结果。但是我直接用上面的，就两边自动给我加了单引号，也什么啊，怎么去掉呢
select a.id,a.dw,a.guest_name,a.hd_note,a.sex,a.post,a.tel,a.email,a.is_js,a.is_js_fc,a.is_live,a.id_card,a.laiyuan,a.remarks,a.daoda_time,a.daoda_dd,a.chufa_time,a.chufa_dd,a.cx_date,a.cx_no,a.fc_date,a.fc_no,a.createtime,a.room,a.dwname ,c.ksmc from JT_ACT_HZHHF a left join jt_act_ksda c on a.dw=c.id where a.corp_id='TZ' and a.id in (select hzhhf_id from JT_ACT_JSAP where id='54')

select a.id,a.dw,a.guest_name,a.hd_note,a.sex,a.post,a.tel,a.email,a.is_js,a.is_js_fc,a.is_live,a.id_card,a.laiyuan,a.remarks,a.daoda_time,a.daoda_dd,a.chufa_time,a.chufa_dd,a.cx_date,a.cx_no,a.fc_date,a.fc_no,a.createtime,a.room,a.dwname ,c.ksmc from JT_ACT_HZHHF a left join jt_act_ksda c on a.dw=c.id where a.corp_id='TZ' and a.id in (266,267)

慕粉1469801537 2019-06-24

源自：Spring入门 3-1 IOC和DI的概念

收起

2回答

好帮手慕阿满 2019-06-24 19:39:07

同学你好，问一下同学hzhhf_id的字段类型是整型的吗？另外建议同学单独查询一下select hzhhf_id from JT_ACT_JSAP where id='54'，查看返回值是否带有单引号。

祝：学习愉快~

收起回答

好帮手慕阿满 2019-06-24 17:31:45

同学你好，同学说的自动添加了单引号，是在哪里添加了单引号呢？建议同学详细描述一下。

祝：学习愉快~

收起回答

提问者慕粉1469801537 #1

select a.id,a.dw,a.guest_name,a.hd_note,a.sex,a.post,a.tel,a.email,a.is_js,a.is_js_fc,a.is_live,a.id_card,a.laiyuan,a.remarks,a.daoda_time,a.daoda_dd,a.chufa_time,a.chufa_dd,a.cx_date,a.cx_no,a.fc_date,a.fc_no,a.createtime,a.room,a.dwname ,c.ksmc from JT_ACT_HZHHF a left join jt_act_ksda c on a.dw=c.id where a.corp_id='TZ' and a.id in ('266,267')就是这个最后添加了单引号

2019-06-24 17:50:01