begin
select * from
dbo.Z_UserAddress
where
([Name] like @SearchStr or
[Title] like @SearchStr)
and Dept_Id = @deptId
end
现在想直接改成
begin
select * from
dbo.Z_UserAddress
where
(@str)
and Dept_Id = @deptId
end
怎么改? 请高手们指教
第1个回答 2011-06-12
SQL语句的拼接问题.
第2个回答 2011-06-12
declare @str varchar(200);
set @str = '([Name] like ''' + @SearchStr + ''' or [Title] like ''' + @SearchStr)+ ''' ';本回答被网友采纳
set @str = '([Name] like ''' + @SearchStr + ''' or [Title] like ''' + @SearchStr)+ ''' ';本回答被网友采纳