你单独测试一下你的这句话,就会看出问题 select * from handset_find where handset_number=@a2
if upper(@a1)='LSGA' begin print 'LSGA' if EXISTS(select * from handset_find where handset_number=@a2) begin print 'exists' insert into BOX_MT (mobile,message,feetype,feevalue) values (@Feemobile,'true','0','0') end else insert into BOX_MT (mobile,message,feetype,feevalue) values (@Feemobile,'false','0','0') end else print 'not match'
select * from handset_find where handset_number=@a2
begin
print 'LSGA'
if EXISTS(select * from handset_find where handset_number=@a2)
begin
print 'exists'
insert into BOX_MT (mobile,message,feetype,feevalue) values (@Feemobile,'true','0','0')
end
else
insert into BOX_MT (mobile,message,feetype,feevalue) values (@Feemobile,'false','0','0')
end
else
print 'not match'