Question

sql 的多条件模糊查询的存储过程应该如何写呢

以下是我写的代码，if里面的 set @strWhere 怎样写都不对，真不知应该怎样写，寻高手求助~~！！！ CREATE PROCEDURE [dbo].[query_class] -- Add the parameters for the stored procedure here @stduent_id int, @student_name nchar (10) AS declare @strWhere varchar(500), @strMAIN varchar(500) BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. set @strWhere='1=1 ' if(@stduent_id!=null) set @strWhere = @strWhere+' and table_class.student_id like ''%''+@student_id+''%''' if(@student_name!=null) set @strWhere = @strWhere+' and table_class.student_name like ''%''+@student_name+''%''' set @strMAIN = 'SELECT LTRIM (RTRIM((table_class.student_id)))AS 学号 , LTRIM (RTRIM((table_class.student_name))) AS 学生名字 FROM table_class where '+@strWhere exec(@strMAIN) END

Answer 1

set @strWhere = @strWhere+' and table_class.student_id like ''%'+@student_id+'%'''