初学SQL变量表，请问一个调用变量表的有关问题，多谢

初学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() );
}
看能不能得到错误的提示信息。
[解决办法]
不懂为啥……

不过……不能用过程吗？