字符串拼接有关问题 like 和 @对象如何拼接
字符串拼接问题 like 和 @对象怎么拼接
DECLARE @a int
SET @a=1
select * from Commodities where symptom like '%'+@a+'%'
将nvarchar值转换int失败
怎么凭借
------解决思路----------------------
------解决思路----------------------
------解决思路----------------------
------解决思路----------------------
也可以这样
------解决思路----------------------
declare @a='%'+1+'%'
select * from Commodities where symptom like @a
DECLARE @a int
SET @a=1
select * from Commodities where symptom like '%'+@a+'%'
将nvarchar值转换int失败
怎么凭借
------解决思路----------------------
DECLARE @a int,@Sql varchar(1000)
SET @a=1
set @Sql=' select * from Commodities where symptom like ''%'+cast(@a as varchar)+'%'''
print @sql
------解决思路----------------------
--输出结果集
exec(@sql)
------解决思路----------------------
DECLARE @a varchar(50)
SET @a='%1'
select * from Commodities where symptom like @a
------解决思路----------------------
也可以这样
declare @a int;
set @a = 1;
select '%' + CONVERT(varchar(10),@a) + '%';
------解决思路----------------------
declare @a='%'+1+'%'
select * from Commodities where symptom like @a