22,209
社区成员
发帖
与我相关
我的任务
分享
DECLARE @s VARCHAR(100)='userID=''36C2A876-E439-495F-8604-934E7342CB77'''
;WITH tableName(Content) AS(
SELECT 'aaaaauserID=''36C2A876-E439-495F-8604-934E7342CB77''uuuuuu'
)
select * from tableName where Content like '%'+@s+'%'
WITH tableName(Content) AS(
SELECT 'aaaaauserID=''36C2A876-E439-495F-8604-934E7342CB77''uuuuuu'
)
select * from tableName where Content like '%userID=''36C2A876-E439-495F-8604-934E7342CB77''%'
Content
--------------------------------------------------------
aaaaauserID='36C2A876-E439-495F-8604-934E7342CB77'uuuuuu
create table test(name varchar(30))
go
insert into test values('ABD'),('ABC'),('ACC')
go
declare @par varchar(10)
set @par = 'C'
select * from test where name like '%' + @par + '%'
go
drop table test
go
(3 行受影响)
name
------------------------------
ABC
ACC
(2 行受影响)