SQL Server参数化查询中应用Like
时间:2022-03-10 17:51
一般情况下是SQL语句:
Select * From Users Where UserName Like ‘Lin%‘
Select * From Users Where UserName Like ‘Lin%‘
采用参数化SQL
DECLARE @pattern VARCHAR(MAX) SET @pattern=Lin%‘ Select * From Users Where UserName Like @pattern
SQL Server参数化查询中应用Like,布布扣,bubuko.com