declare @name nvarchar(50);
declare @name_pin nvarchar(50);
set @name_pin = ‘%‘+@name +‘%‘
模糊查询：
select @name = name from [DataBase] where name like @name_pin
SQLSEVER在存储过程或触发器中模糊查询拼接
原文：https://www.cnblogs.com/dosoftwarey/p/11703690.html
