一般情况下是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语句:
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
转载于:https://www.cnblogs.com/sunsoftresearch/p/3819269.html