exec sp_executesql N'SELECT *,p.PersonnelCode,PaperTitle from
ExamTestee AS e
, PersonnelBase as p
, PaperMaster as m
WHERE e.PersonnelID = p.PersonnelID
AND m.PaperID = e.PaperID And (PersonnelCode Like ''%@CodeOrName%''
OR p.PersonnelName like ''%@CodeOrName%'') Order By
p.PersonnelCode ',
N'@CodeOrName varchar(50)',
@CodeOrName='伟'语法都是没问题,就是不知道为什么,没结果....
ExamTestee AS e
, PersonnelBase as p
, PaperMaster as m
WHERE e.PersonnelID = p.PersonnelID
AND m.PaperID = e.PaperID And (PersonnelCode Like ''%@CodeOrName%''
OR p.PersonnelName like ''%@CodeOrName%'') Order By
p.PersonnelCode ',
N'@CodeOrName varchar(50)',
@CodeOrName='伟'语法都是没问题,就是不知道为什么,没结果....
ExamTestee AS e
, PersonnelBase as p
, PaperMaster as m
WHERE e.PersonnelID = p.PersonnelID
AND m.PaperID = e.PaperID And (PersonnelCode Like '%伟%'
OR p.PersonnelName like '%伟%' ) Order By
p.PersonnelCode 这个先查下有没能结果
declare @CodeOrName nvarchar(10)
set @CodeOrName=N'伟大'
set @sql=N'SELECT *,p.PersonnelCode,PaperTitle from
ExamTestee AS e
, PersonnelBase as p
, PaperMaster as m
WHERE e.PersonnelID = p.PersonnelID
AND m.PaperID = e.PaperID And (PersonnelCode Like ''%'+@CodeOrName+'%''
OR p.PersonnelName like ''%'+@CodeOrName+'%'') Order By
p.PersonnelCode '
exec(@sql)
ExamTestee AS e
, PersonnelBase as p
, PaperMaster as m
WHERE e.PersonnelID = p.PersonnelID
AND m.PaperID = e.PaperID And (PersonnelCode Like N''%@CodeOrName%''
OR p.PersonnelName like N''%@CodeOrName%'') Order By
p.PersonnelCode ',
N'@CodeOrName nvarchar(50)',
@CodeOrName=N'伟'如果有结果,这样试下
ExamTestee AS e
, PersonnelBase as p
, PaperMaster as m
WHERE e.PersonnelID = p.PersonnelID
AND m.PaperID = e.PaperID And (PersonnelCode Like N''%''+@CodeOrName+''%''
OR p.PersonnelName like N''%@CodeOrName%'') Order By
p.PersonnelCode ',
N'@CodeOrName nvarchar(50)',
@CodeOrName=N'伟'改为这样,问题解决。
ExamTestee AS e
, PersonnelBase as p
, PaperMaster as m
WHERE e.PersonnelID = p.PersonnelID
AND m.PaperID = e.PaperID And (PersonnelCode Like N''%''+@CodeOrName+''%''
OR p.PersonnelName like N''%''+@CodeOrName+''%'') Order By
p.PersonnelCode ',
N'@CodeOrName nvarchar(50)',
@CodeOrName=N'伟'你那个还是双包胎的,再来一下。