declare @varYF 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 @varXMBH='200083215'
set @varZRZX ='21011324'
set @varKMBH='1002'
set @intBMJC=4set @varSql ='SELECT SUBSTRING(WLBMDM,1,4) AS WLBH, SUM(QCJFYE) AS QCJFYE INTO #TB_TEMP
FROM XT_FZB_'+@varXMBH+ substring('+@varYF+',1,4) +'
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+substring('+@varYF+',1,4) +' B WHERE A.WLBH=B.WLBMDM
DROP TABLE #TB_TEMP ' print @varSql 结果显示:(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
Server Message: Number 2747, Severity 16
Server 'sjcs', Line 21:
Incorrect position specifier in format string of PRINT command.
declare @varXMBH VARCHAR(9)
declare @varZRZX varchar(200)
declare @varKMBH VARCHAR(200)
declare @intBMJC int
declare @varSql varchar(2000)set @varYF ='200601'
set @varXMBH='200083215'
set @varZRZX ='21011324'
set @varKMBH='1002'
set @intBMJC=4set @varSql ='SELECT SUBSTRING(WLBMDM,1,4) AS WLBH, SUM(QCJFYE) AS QCJFYE INTO #TB_TEMP
FROM XT_FZB_'+@varXMBH+ substring('+@varYF+',1,4) +'
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+substring('+@varYF+',1,4) +' B WHERE A.WLBH=B.WLBMDM
DROP TABLE #TB_TEMP ' print @varSql 结果显示:(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
Server Message: Number 2747, Severity 16
Server 'sjcs', Line 21:
Incorrect position specifier in format string of PRINT command.
解决方案 »
- 有没有可以检查数据库设计是否规范的软件
- 做一查询系统,如何存储用户的图片?
- 请问下。。sql怎么判断一个个月的第一周,第二周,第三周
- 向你请教:select top 语句后面可以跟变量吗?例子如下:请大侠帮助。
- insert的奇怪问题
- 数据库的设计 召唤高手解决
- 能否通过互联网使用数据库的复制功能?
- 求sql。
- 查询分析器测试存储过程时抱的错误Server: Msg 229, Level 14, Procedure sp_sdidebug,[SQL Server]拒绝了对对象 'sp_sdidebug'(数据库
- 高手们,帮我看看这个简单的存储过程查询不到结果?
- 要一个句SQL---------------------------(在线等)
- 请教一个思路,确定某工序已完工,从流程上讲,应该有专人确认呀,还是能过产量来确定其已完工
declare @varYF 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 @varXMBH='200083215'
set @varZRZX ='21011324'
set @varKMBH='1002'
set @intBMJC=4set @varSql ='SELECT SUBSTRING(WLBMDM,1,4) AS WLBH, SUM(QCJFYE) AS QCJFYE INTO #TB_TEMP
FROM XT_FZB_'+@varXMBH+ substring(@varYF,1,4) +'
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+substring(@varYF,1,4) +' B WHERE A.WLBH=B.WLBMDM
DROP TABLE #TB_TEMP ' print @varSql
declare @varXMBH VARCHAR(9)
declare @varZRZX varchar(200)
declare @varKMBH VARCHAR(200)
declare @intBMJC int
declare @varSql varchar(2000)set @varYF ='200601'
set @varXMBH='200083215'
set @varZRZX ='21011324'
set @varKMBH='1002'
set @intBMJC=4set @varSql ='SELECT SUBSTRING(WLBMDM,1,4) AS WLBH, SUM(QCJFYE) AS QCJFYE INTO #TB_TEMP
FROM XT_FZB_'+@varXMBH+ 'substring('+@varYF+',1,4)' +'
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+'substring('+@varYF+',1,4) '+' B WHERE A.WLBH=B.WLBMDM
DROP TABLE #TB_TEMP ' print @varSql
declare @varXMBH VARCHAR(9)
declare @varZRZX varchar(200)
declare @varKMBH VARCHAR(200)
declare @intBMJC int
declare @varSql varchar(2000)set @varYF ='200601'
set @varXMBH='200083215'
set @varZRZX ='21011324'
set @varKMBH='1002'
set @intBMJC=4set @varSql ='SELECT SUBSTRING(WLBMDM,1,4) AS WLBH, SUM(QCJFYE) AS QCJFYE INTO #TB_TEMP
FROM XT_FZB_'+@varXMBH+ substring(@varYF,1,4) +'
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+substring(@varYF,1,4) +' B WHERE A.WLBH=B.WLBMDM;
DROP TABLE #TB_TEMP ' print @varSql
Server 'sjcs', Line 21:
Incorrect position specifier in format string of PRINT command. 在你上面的代碼中沒有sjcs這樣的東西,你的代碼是不是沒有貼全?
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)