初学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没写对阿，谢谢


[解决办法]
把sql语句打印出来，放到sql的查询分析中执行一下就知道了
[解决办法]
用try....catch试试
catch( _com_err &e )
{
AfxMessageBox( e.Description() );
}
看能不能得到错误的提示信息。
[解决办法]
不懂为啥……

不过……不能用过程吗？