初学SQL变量表,请教一个调用变量表的问题,谢谢
VC下调用
strQuery = "DECLARE @sfc TABLE (pzhhh varchar(20),rkshl int,chkshl int,rkje [decimal](18, 2),chkje [decimal](18, 2),ptje [decimal](18, 2),qcshl int,qcje [decimal](18, 2)) \
INSERT INTO @sfc(pzhhh,qcshl,qcje) SELECT pzhhh,qcshl,qcje from zhixiaochuribao where bm='"+m_bm+"' and date='"+date1+"' \
INSERT INTO @sfc(pzhhh,rkshl,rkje) select pzhhh,sum(shl),sum(je) from zhixiaochurk where bm='"+m_bm+"' and rkdate between '"+date1+"' and '"+date2+"' group by pzhhh \
INSERT INTO @sfc(pzhhh,chkshl,chkje,ptje) select pzhhh,sum(shl),sum(je),sum(ptje) from zhixiaochuchk where bm='"+m_bm+"' and date between '"+date1+"' and '"+date2+"' group by pzhhh \
select pzhhh,sum(qcshl),sum(qcje),sum(rkshl),sum(rkje),sum(chkshl),sum(chkje),sum(ptje) from @sfc group by pzhhh order by pzhhh";
theApp.ADOExecute(theApp.m_pADOSet, strQuery);
运行出错,是SQL语句有问题,还是VC没写对阿,谢谢