这样写有问题吗/调用总是不成功??
CREATE PROCEDURE Var_BatchStock_2@ME001 CHAR(20),
@ME001_2 CHAR(20),
@LA009 CHAR(1000)
DECLARE
@strSQL varchar(2000)
SET @strSQL=select * from CMSMA WHERE WHERE ((ME001 Between '+@ME001+' and '+@ME001_2+') and (LA009 IN ('+@LA009+'))
exec(@strSQL)能帮帮我看看吗?
CREATE PROCEDURE Var_BatchStock_2@ME001 CHAR(20),
@ME001_2 CHAR(20),
@LA009 CHAR(1000)
DECLARE
@strSQL varchar(2000)
SET @strSQL=select * from CMSMA WHERE WHERE ((ME001 Between '+@ME001+' and '+@ME001_2+') and (LA009 IN ('+@LA009+'))
exec(@strSQL)能帮帮我看看吗?
===============
怎么会有两个Where?
CREATE PROCEDURE Var_BatchStock_2@ME001 CHAR(20),
@ME001_2 CHAR(20),
@LA009 CHAR(1000)
DECLARE
@strSQL varchar(2000)
SET @strSQL='select * from CMSMA WHERE ((ME001 Between '+@ME001+' and '+@ME001_2+') and (LA009 IN ('+@LA009+'))'
exec(@strSQL)能帮帮我看看吗?
我想问题在这里
select @ME001_2 = 'bbb'
拼接以后就是这样
select * from CMSMA WHERE ((ME001 Between aaa and bbb)....后面省略
但问题是@ME001是char类型
所以这里是不是应该这样
select * from CMSMA WHERE ((ME001 Between 'aaa' and 'bbb')....后面省略