代碼如下，請問轉到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 '用戶編號','用戶姓名','小區','樓號','單元號','房間號','票據單號','上次余額','現金余額','實收金額','操作員','操作型別' "
uj5u.com熱心網友回復：
sql server 也有shape陳述句阿具體的你看這里
http://support.microsoft.com/kb/189657
uj5u.com熱心網友回復：
非常感謝
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/112472.html
標籤：VB基礎類
上一篇：關于asp的奇怪問題