代码如下,请问转到SQL SERVER数据库时,代码如何改写,谢谢大家。
sql = " SHAPE {SELECT c.用户编号, c.用户姓名, c.小区, c.楼号, c.单元号, c.房间号, c.表序号, c.表型名称, c.计费类型, c.计费类别, c.单价, c.购买次数, " _
& " c.购买量, c.购买金额, c.操作日期, c.操作员, c.操作次数, c.总操作次数, c.操作类型, c.票据单号, c.有效性, d.上次余额, d.现金余额, 实收金额 " _
& " FROM " _
& " ( " _
& " ( " _
& " SELECT b.用户编号, b.用户姓名, b.小区, b.楼号, b.单元号, b.房间号, b.表序号, b.表型名称, " _
& " b.计费类型, b.计费类别, b.单价, b.购买次数, b.购买量, b.购买金额, b.操作日期, b.操作员, " _
& " b.操作次数, b.总操作次数, b.操作类型, b.票据单号, b.有效性, b.修正次数 " _
& " FROM " _
& " (SELECT * FROM yhxx WHERE 用户编号 = " & LBianhao & " ) AS a " _
& " LEFT JOIN " _
& " ( SELECT * FROM sdjl WHERE 用户编号 = " & LBianhao & " AND 票据单号 = " & PJDH & " AND 操作类型 = '购买' " _
& " AND 有效性 = '有效' ORDER BY 表序号" _
& " ) AS b ON a.用户编号 = b.用户编号 " _
& " ) AS c " _
& " LEFT JOIN " _
& " (SELECT * FROM yueb WHERE 用户编号 = " & LBianhao & " AND 票据单号 = " & PJDH & " ) AS d " _
& " ON c.用户编号 = d.用户编号 AND c.票据单号 = d.票据单号 " _
& " ) order by c.用户编号,c.表序号,c.操作日期 " _
& " } AS Command1 COMPUTE Command1 as Command2 BY '用户编号','用户姓名','小区','楼号','单元号','房间号','票据单号','上次余额','现金余额','实收金额','操作员','操作类型' "
sql = " SHAPE {SELECT c.用户编号, c.用户姓名, c.小区, c.楼号, c.单元号, c.房间号, c.表序号, c.表型名称, c.计费类型, c.计费类别, c.单价, c.购买次数, " _
& " c.购买量, c.购买金额, c.操作日期, c.操作员, c.操作次数, c.总操作次数, c.操作类型, c.票据单号, c.有效性, d.上次余额, d.现金余额, 实收金额 " _
& " FROM " _
& " ( " _
& " ( " _
& " SELECT b.用户编号, b.用户姓名, b.小区, b.楼号, b.单元号, b.房间号, b.表序号, b.表型名称, " _
& " b.计费类型, b.计费类别, b.单价, b.购买次数, b.购买量, b.购买金额, b.操作日期, b.操作员, " _
& " b.操作次数, b.总操作次数, b.操作类型, b.票据单号, b.有效性, b.修正次数 " _
& " FROM " _
& " (SELECT * FROM yhxx WHERE 用户编号 = " & LBianhao & " ) AS a " _
& " LEFT JOIN " _
& " ( SELECT * FROM sdjl WHERE 用户编号 = " & LBianhao & " AND 票据单号 = " & PJDH & " AND 操作类型 = '购买' " _
& " AND 有效性 = '有效' ORDER BY 表序号" _
& " ) AS b ON a.用户编号 = b.用户编号 " _
& " ) AS c " _
& " LEFT JOIN " _
& " (SELECT * FROM yueb WHERE 用户编号 = " & LBianhao & " AND 票据单号 = " & PJDH & " ) AS d " _
& " ON c.用户编号 = d.用户编号 AND c.票据单号 = d.票据单号 " _
& " ) order by c.用户编号,c.表序号,c.操作日期 " _
& " } AS Command1 COMPUTE Command1 as Command2 BY '用户编号','用户姓名','小区','楼号','单元号','房间号','票据单号','上次余额','现金余额','实收金额','操作员','操作类型' "
解决方案 »
- 如何用vb访问网上的asp,asp里脚本语言是xml,用vb写的程序访问后,分析xml里的数据
- 散分,还请帮忙参考买个笔记本
- 菜鸟提问!!!!!求高手解答
- 高分求助!关于utf-8的问题
- 各位大侠救我 关于EPSON LQ-300K打印问题
- 用 datareport 打印报表,不能用代码控制打印纸尺寸
- 在treeviem上单击右键为什么没有属性窗口?
- 求一份基于cs影院售票系统 求大神出手。。。。QQ是86115564 谢谢各位大神
- ADO高手帮忙呀,,,谢谢,,紧急
- 关于VB中写的COM+程序中调用DLL的问题
- 刚学习ACCESS,用VB添加事件过程,总是报错
- 如何从安装有SQL SERVER2008的服务器上获取到时间
http://support.microsoft.com/kb/189657