日期:2014-05-19  浏览次数:20874 次

"#VAR1#","#VAR2#"这样的字符代表什么意思阿?
sql   =   "SELECT   LEFT(QSDM,   #VAR1#),   CURRENTYEAR,   "
                                                +   "   SUM(A1)   AS   A1,   SUM(A2)   AS   A2,   SUM(A3)   AS   A3,   "
                                                +   "   SUM(A11)   AS   A11,   SUM(A12)   AS   A12,   SUM(A13)   AS   A13,   SUM(A14)   AS   A14,   SUM(A15)   AS   A15,   "
                                                +   "   SUM(A20)   AS   A20,   SUM(A26)   AS   A26,   SUM(A27)   AS   A27,   SUM(A31)   AS   A31,   SUM(A32)   AS   A32,   "
                                                +   "   SUM(A111)   AS   A111,   SUM(A112)   AS   A112,   SUM(A113)   AS   A113,   SUM(A114)   AS   A114,   SUM(A115)   AS   A115,   SUM(A121)   AS   A121,   SUM(A121K)   AS   A121K,   "
                                                +   "   SUM(A122)   AS   A122,   SUM(A122K)   AS   A122K,   SUM(A123)   AS   A123,   SUM(A123K)   AS   A123K,   SUM(A124)   AS   A124,   SUM(A124K)   AS   A124K,   SUM(A125)   AS   A125,   "
                                                +   "   SUM(A125K)   AS   A125K,   SUM(A131)   AS   A131,   SUM(A131K)   AS   A131K,   SUM(A132)   AS   A132,   SUM(A133)   AS   A133,   SUM(A134)   AS   A134,   SUM(A134K)   AS   A134K,   "
                                                +   "   SUM(A135)   AS   A135,   SUM(A136)   AS   A136,   SUM(A136K)   AS   A136K,   SUM(A141)   AS   A141,   SUM(A142)   AS   A142,   SUM(A143)   AS   A143,   SUM(A143K)   AS   A143K,   "
                                                +   "   SUM(A151)   AS   A151,   SUM(A152)   AS   A152,   SUM(A153)   AS   A153,   SUM(A154)   AS   A154,   SUM(A155)   AS   A155,   SUM(A155K)   AS   A155K,   SUM(A156)   AS   A156,   "