我有一段VB+SQL代码如下,由于代码太长,如何分多行书写.用下划线“_”不行报出错
myvograde.rsDK1 "declare @id int,@sj datetime,@rq smalldatetime,@lx varchar(6),@xl varchar(20),@ch varchar(10),@dm varchar(10),@nr varchar(80),@gl int,@zh varchar(10),@xm varchar(10),@dd varchar(20),@jc varchar(20),@num int,@jdm varchar(10),@jnr varchar(80),@jzh varchar(10),@jxm varchar(10),@jzh1 varchar(10),@jxm1 varchar(10),@jsj datetime,@yh1 varchar(10),@yh2 varchar(10),@dw varchar(20),@gf bit,@bm varchar(10),@bz varchar(10),@cm varchar(10) set @id=m_id set @sj=m_bxsj set @rq=m_bxrq set @lx=m_bxlx set @xl=m_cd set @ch=m_ch set @dm=m_bxdm set @nr=m_bxnr set @gl =m_gl set @zh=m_bxr set @xm=m_bxrxm set @dd=m_tcdd set @jc=m_jcmc set @num=m_num set @jdm=m_jxdm set @jnr=m_jxnr set @jzh=m_jxr set @jxm=m_jxrxm set @jzh1=m_jxr1 set @jxm1 =m_jxrxm1 set @jsj=m_jxsj set @yh1=m_user1 set @yh2=m_user2 set @dw=m_xldw set @gf=m_gfjl set @bm=m_bm set @bz=m_bz set @cm=m_cm exec qd_bdvolvo @id,@sj,@rq,@lx,@xl,@ch,@dm,@nr,@gl,@zh,@xm,@dd,@jc,@num,@jdm,@jnr,@jzh,@jxm,@jzh1,@jxm1,@jsj,@yh1,@yh2,@dw,@gf,@bm,@bz,@cm"
myvograde.rsDK1 "declare @id int,@sj datetime,@rq smalldatetime,@lx varchar(6),@xl varchar(20),@ch varchar(10),@dm varchar(10),@nr varchar(80),@gl int,@zh varchar(10),@xm varchar(10),@dd varchar(20),@jc varchar(20),@num int,@jdm varchar(10),@jnr varchar(80),@jzh varchar(10),@jxm varchar(10),@jzh1 varchar(10),@jxm1 varchar(10),@jsj datetime,@yh1 varchar(10),@yh2 varchar(10),@dw varchar(20),@gf bit,@bm varchar(10),@bz varchar(10),@cm varchar(10) set @id=m_id set @sj=m_bxsj set @rq=m_bxrq set @lx=m_bxlx set @xl=m_cd set @ch=m_ch set @dm=m_bxdm set @nr=m_bxnr set @gl =m_gl set @zh=m_bxr set @xm=m_bxrxm set @dd=m_tcdd set @jc=m_jcmc set @num=m_num set @jdm=m_jxdm set @jnr=m_jxnr set @jzh=m_jxr set @jxm=m_jxrxm set @jzh1=m_jxr1 set @jxm1 =m_jxrxm1 set @jsj=m_jxsj set @yh1=m_user1 set @yh2=m_user2 set @dw=m_xldw set @gf=m_gfjl set @bm=m_bm set @bz=m_bz set @cm=m_cm exec qd_bdvolvo @id,@sj,@rq,@lx,@xl,@ch,@dm,@nr,@gl,@zh,@xm,@dd,@jc,@num,@jdm,@jnr,@jzh,@jxm,@jzh1,@jxm1,@jsj,@yh1,@yh2,@dw,@gf,@bm,@bz,@cm"
"declare @id int,@sj datetime,@rq smalldatetime,@lx varchar(6),@xl varchar(20),@ch varchar(10),@dm varchar(10),@nr varchar(80),@gl int,@zh varchar(10),@xm varchar(10),@dd varchar(20),@jc varchar(20),@num int,@jdm varchar(10),@jnr varchar(80),@jzh varchar(10),@jxm varchar(10),@jzh1 varchar(10),@jxm1 varchar(10),@jsj datetime,@yh1 varchar(10),@yh2 varchar(10),@dw varchar(20),@gf bit,@bm varchar(10),@bz varchar(10),@cm varchar(10)
set @id=m_id
set @sj=m_bxsj
set @rq=m_bxrq
set @lx=m_bxlx
set @xl=m_cd
set @ch=m_ch
set @dm=m_bxdm
set @nr=m_bxnr
set @gl =m_gl
set @zh=m_bxr
set @xm=m_bxrxm
set @dd=m_tcdd
set @jc=m_jcmc
set @num=m_num
set @jdm=m_jxdm
set @jnr=m_jxnr
set @jzh=m_jxr
set @jxm=m_jxrxm
set @jzh1=m_jxr1
set @jxm1 =m_jxrxm1
set @jsj=m_jxsj
set @yh1=m_user1
set @yh2=m_user2
set @dw=m_xldw
set @gf=m_gfjl
set @bm=m_bm
set @bz=m_bz
set @cm=m_cm exec qd_bdvolvo @id,@sj,@rq,@lx,@xl,@ch,@dm,@nr,@gl,@zh,@xm,@dd,@jc,@num,@jdm,@jnr,@jzh,@jxm,@jzh1,@jxm1,@jsj,@yh1,@yh2,@dw,@gf,@bm,@bz,@cm"
"declare @id int,@sj datetime " + _
",@rq smalldatetime,...... "
& " values (....."