34,590
社区成员
发帖
与我相关
我的任务
分享
create table Inventory2
(
[name] varchar(20)
)
delete from Inventory2
insert into Inventory2
select 'AADDDTTT' union all
select 'AADDDFFF' union all
select 'AADD' union all
select 'AADEFFD'
declare @pName varchar(20)
set @pName = 'AADDDFFF'
select * from Inventory2
where [Name] LIKE '%'+@pName+'%'
name
--------------------
AADDDFFF
(1 行受影响)
select * from Inventory2
where @pName LIKE '%'+[Name]+'%'
name
--------------------
AADDDFFF
AADD
(2 行受影响)