简单问题又发一帖，用变量替换后不出结果，为啥？请赐教
declare @varYF VARCHAR(4)
declare @varYEAR VARCHAR(4)
declare @varXMBH VARCHAR(9)
declare @varZRZX varchar(200)
declare @varKMBH VARCHAR(200)
declare @intBMJC int
declare @varSql varchar(2000)
set @varYF = '200601 '
set @varYEAR= '2006 '
set @varXMBH= '200083215 '
set @varZRZX = '21011324 '
set @varKMBH= '1002 '
set @intBMJC=4
set @varSql= 'SELECT SUBSTRING(WLBMDM,1,4) AS WLBH, SUM(QCJFYE) AS QCJFYE INTO #TB_TEMP
FROM XT_FZB_ '+@varXMBH+ @varYEAR+ '
WHERE ZRZX like ' ' '+@varZRZX + '% ' ' AND KMBH LIKE ' ' '+@varKMBH + '% ' ' AND YF= ' ' '+@varYF + ' ' '
AND WLBMDM IS NOT NULL GROUP BY SUBSTRING(WLBMDM,1,4)
SELECT A.WLBH,B.WLBMMC FROM #TB_TEMP A, XT_BMK_ '+@varXMBH+@varYEAR+ ' B WHERE A.WLBH=B.WLBMDM '
/* set @varSql= 'SELECT SUBSTRING(WLBMDM,1,4) AS WLBH, SUM(QCJFYE) AS QCJFYE INTO #TB_TEMP
FROM XT_FZB_2000832152006
WHERE ZRZX like ' '21011324% ' ' AND KMBH LIKE ' '1002% ' ' AND YF= ' '200601 ' '
AND WLBMDM IS NOT NULL GROUP BY SUBSTRING(WLBMDM,1,4)
SELECT A.WLBH,B.WLBMMC FROM #TB_TEMP A, XT_BMK_2000832152006 B WHERE A.WLBH=B.WLBMDM ' */
exec(@varSql)
[解决办法]
检查一下这句话
SELECT SUBSTRING(WLBMDM,1,4) AS WLBH, SUM(QCJFYE) AS QCJFYE INTO #TB_TEMP
FROM XT_FZB_2000832152006
WHERE ZRZX like '21011324% ' AND KMBH LIKE '1002% ' AND YF= '2006 '
AND WLBMDM IS NOT NULL GROUP BY SUBSTRING(WLBMDM,1,4)
SELECT A.WLBH,B.WLBMMC FROM #TB_TEMP A, XT_BMK_2000832152006 B WHERE A.WLBH=B.WLBMDM
[解决办法]
沒看到錯誤，錯誤提示還是那個？
[解决办法]
单引号错误
[解决办法]
你把它拆开执行不好吗？前面到
select 等号右边 as aa 应该得到一个字符串
SELECT SUBSTRING(WLBMDM,1,4) AS WLBH, SUM(QCJFYE) AS QCJFYE INTO #TB_TEMP
FROM XT_FZB_2000832152006
WHERE ZRZX like '21011324% ' AND
KMBH LIKE '1002% ' AND
YF= '2006 ' AND
WLBMDM IS NOT NULL
GROUP BY SUBSTRING(WLBMDM,1,4)
结束，exec(xxx)
然后
SELECT A.WLBH,B.WLBMMC F
现在你拼出的sql最后面是SELECT A.WLBH,B.WLBMMC F而不是group by就结束，是两个语句
[解决办法]
用 print @varSql 将动态的Sql语句打印出来看看，和没有拼的语句比较一下有什么区别
like ' ' '+@varZRZX + '% ' ' AND KMBH LIKE ' ' '+@varKMBH + '% ' '
这句话的嫌疑最大，因为不知道 @varZRZX 变量中是连接以后到底是什么
[解决办法]
这样试试
declare @varYF VARCHAR(4)
declare @varYEAR VARCHAR(4)
declare @varXMBH VARCHAR(9)
declare @varZRZX varchar(200)
declare @varKMBH VARCHAR(200)
declare @intBMJC int
declare @varSql varchar(2000)
set @varYF = '200601 '
set @varYEAR= '2006 '
set @varXMBH= '200083215 '
set @varZRZX = '21011324 '
set @varKMBH= '1002 '
set @intBMJC=4
set @varSql= 'SELECT SUBSTRING(WLBMDM,1,4) AS WLBH, SUM(QCJFYE) AS QCJFYE INTO #TB_TEMP
FROM XT_FZB_ '+@varXMBH+ @varYEAR+ '
WHERE ZRZX like ' ' '+@varZRZX + '% ' ' AND KMBH LIKE ' ' '+@varKMBH + '% ' ' AND YF= ' ' '+@varYF + ' ' '
AND WLBMDM IS NOT NULL GROUP BY SUBSTRING(WLBMDM,1,4) '
exec(@varSql)
set @varSql= 'SELECT A.WLBH,B.WLBMMC FROM #TB_TEMP A, XT_BMK_ '+@varXMBH+@varYEAR+ ' B WHERE A.WLBH=B.WLBMDM '
exec(@varSql)
