请问该在那几处给@lshj赋值呢? 我在set @ydjbh='' set @spbh='' set @spid='' 此处加了set @lshj='' 还有一处select @ydjbh=case fieldname when 'ydjbh' then left(fieldvalue,11) else @ydjbh end, @spbh=case fieldname when 'spbh' then left(fieldvalue,15) else @spbh end , @spid=case fieldname when 'spid' then left(fieldvalue,11) else @spid end , 此处加了@lshj = case when fieldname='lshj' and isnumeric(fieldvalue)=1 then cast(left(fieldvalue,50) as int) else @lshj end , @shlv = case when fieldname='shlv' and isnumeric(fieldvalue)=1 then cast(left(fieldvalue,50) as int) else @shlv end , 后语法检查没有错误。但就是不执行!
values(@spid , @spbh,@lshj ,@shlv)insert into spkfk(spid ,spbh,lshj ,shlv)
values(@spid , @spbh,@lshj ,@shlv)
set @spbh=''
set @spid=''
此处加了set @lshj=''
还有一处select @ydjbh=case fieldname when 'ydjbh' then left(fieldvalue,11) else @ydjbh end,
@spbh=case fieldname when 'spbh' then left(fieldvalue,15) else @spbh end ,
@spid=case fieldname when 'spid' then left(fieldvalue,11) else @spid end ,
此处加了@lshj = case when fieldname='lshj' and isnumeric(fieldvalue)=1 then cast(left(fieldvalue,50) as int) else @lshj end ,
@shlv = case when fieldname='shlv' and isnumeric(fieldvalue)=1 then cast(left(fieldvalue,50) as int) else @shlv end , 后语法检查没有错误。但就是不执行!