好像这部分 set @sqlStr=@sqlStr+' and fhts='+''''+@fhts+''' ' 也有问题哦
大家帮我这部分看看 set @sqlStr=@sqlStr+' and fhts='+''''+@fhts+''' '
你都不结帖谁帮你看内?CREATE PROC PROC_EatSearch @eatname varchar(50), @qy varchar(50), @fhts int, @fhzb int AS begin select * from eat where isnull(@eatname,eatname)=eatname and isnull(@qy,qy)=qy and isnull(@fhts,fhts)=fhts and isnull(@fhzb,fhzb)=fhzb end
IF EXISTS(SELECT *FROM SYSOBJECTS WHERE NAME='PROC_EatSearch') DROP PROC PROC_EatSearch GO CREATE PROC PROC_EatSearch (@eatname varchar(50), @qy varchar(50), @fhts int, @fhzb int) AS
dddddddddddd set @sqlStr=@sqlStr+' and fhts='+''''+@fhts+''' ' 有误
看起来怎么是同一个帖子: 请参考 http://topic.csdn.net/u/20080725/19/00fcef1f-6594-4cda-a22f-05767ad31f8a.html?278463675 2楼你的SQL写的太乱, 可以考虑上例中的方法提高你SQL的逻辑复杂度,减少IF ... END IF;
set @sqlStr=@sqlStr+' and fhts='+''''+@fhts+''' '
也有问题哦
set @sqlStr=@sqlStr+' and fhts='+''''+@fhts+''' '
@eatname varchar(50),
@qy varchar(50),
@fhts int,
@fhzb int
AS
begin
select * from eat where isnull(@eatname,eatname)=eatname and isnull(@qy,qy)=qy
and isnull(@fhts,fhts)=fhts and isnull(@fhzb,fhzb)=fhzb
end
DROP PROC PROC_EatSearch
GO
CREATE PROC PROC_EatSearch
(@eatname varchar(50),
@qy varchar(50),
@fhts int,
@fhzb int)
AS
set @sqlStr=@sqlStr+' and fhts='+''''+@fhts+''' ' 有误
请参考 http://topic.csdn.net/u/20080725/19/00fcef1f-6594-4cda-a22f-05767ad31f8a.html?278463675 2楼你的SQL写的太乱, 可以考虑上例中的方法提高你SQL的逻辑复杂度,减少IF ... END IF;