通过QQ传数据数据内容如下:
select * from vw_inout_signfor
where project_code='0000000027'
and isnull(lastnum,0)<>0
and billtypen='2'
and uf_flag='采购结算'
and isnull(outnum,0)=0
and itemname not like '%水泥%'
我现在加批注
select * from vw_inout_signfor
where project_code='0000000027'
and isnull(lastnum,0)<>0--
and billtypen='2'
and uf_flag='采购结算'
and isnull(outnum,0)=0
and itemname not like '%水泥%'
那么运行的语句为:
select * from vw_inout_signfor
where project_code='0000000027'
and isnull(lastnum,0)<>0
但未通过QQ传,,得到的结果正常..
所以告诉各位...没事不要用QQ传SQL语句...不然造成什么语法错误..找问题找半天也找不到.