declare @test table(
name varchar(100),
password varchar(max)
)
insert into @test values('woaidaddfd','aaa')
insert into @test values('woaidaidddd','bbb')
insert into @test values('woaidbidddd','ccc')
insert into @test values('woaidcifffd','dddd')
select * from @test
select * from @test where patindex('%aida%',name) > 0
select *,datalength(patindex('%d_*i%',name)),datalength(patindex('%b_*i%',password)) from @test where patindex('%d_i%',name) > 0
varchar 与varchar(max)
最新推荐文章于 2023-12-28 16:51:04 发布