set @sqlString='select * from talb1'
set @condition='where 1=1'
set @sqlString=@sqlString+@conditionprint @sqlString结果@sqlString 还是等于'select * from talb1'
set @condition='where 1=1'
set @sqlString=@sqlString+@conditionprint @sqlString结果@sqlString 还是等于'select * from talb1'
set @sqlString='select * from talb1'
set @condition=' where 1=1'
set @sqlString=@sqlString+@conditionprint @sqlString
结果:
select * from talb1 where 1=1
set @sqlString='select * from talb1'
set @condition=' where 1=1'
set @sqlString=@sqlString+@conditionprint @sqlString select * from talb1where 1=1
set @condition='where 1=1' --where前要有空格 set @condition=' where 1=1'
我想给一个参数加一个%在后面就像是:@name是传入的一个参数 ,比如说等于‘name1’set @name=@name+'%'结果print @name的结果是: 'name1'%我想要的是 'name1%'
set @name='name1'
set @name=@name+'%'
print @name--结果,没问题啊
name1%
declare @name varchar(1000)
set @name='name1'
set @name=''''+@name+'%'''
print @name--结果
'name1%'