select N'insert into code_segment(FPREFIX,FPROVINCE,FZONECODE,FZONE,FNUMTYPE,FPVDID,FSYNCFLAG) values('''+fprovince+''','''+fprovince+''')' from tmp_code_segment where fprefix='130'