怎样模糊关联拼接sql比如 a表 和 b表
declare @str varchar(200)
set @str='select a.* from a,b where a.name like ' + '%' + 'b.name' + '%'exec(@str)
这样是错的,请大家帮我给出正确的写法
declare @str varchar(200)
set @str='select a.* from a,b where a.name like ' + '%' + 'b.name' + '%'exec(@str)
这样是错的,请大家帮我给出正确的写法
set @str='select a.* from a,b where a.name like ''' + '%''+' + 'b.name' + '+''%'''
exec(@str)
set @str='select a.* from a,b where a.name like '''%' + 'b.name' + '%''''
declare @str varchar(200)
set @str='select a.* from a,b where a.name like ''%''+' + 'b.name' + '+''%'''
print(@str)看到结果
select a.* from a,b where a.name like '%'+b.name+'%'
set @str='select a.* from a,b where a.name like ''%' + 'b.name' + '%'''exec(@str)
set @str='select a.* from a,b where charindex(b.name,a.name) > 0'
exec(@str)