Ask SQL statements

wumingzhe

The following statement is always debugging
Always remind me that something is wrong nearby like

set @strSql = 'insert into #indextable (CompanyID, CompanyName, Address, Phone, Place)' +
'select CompanyID, CompanyName, Address, Phone, Place from Companywhere Place like%' + @ strPlace + '%'
exec (@strSql)

fanfan1980

--try

set @strSql ='insert into #indextable(CompanyID,CompanyName,Address,Phone,Place)'+
'select CompanyID, CompanyName,Address,Phone,Place from Companywhere Place like''%'+@strPlace+'%'''
exec(@strSql)

cv4bf5d65fd

set @strSql ='insert into #indextable(CompanyID,CompanyName,Address,Phone,Place)'+
'select CompanyID, CompanyName,Address,Phone,Place from Company where Place like''%'+@strPlace+'%'''
exec(@strSql)

unkmass

Less spaces!
set @strSql ='insert into #indextable(CompanyID,CompanyName,Address,Phone,Place)'+
'select CompanyID, CompanyName,Address,Phone,Place from Company where Place like %'+@strPlace+'%'
exec(@strSql)

unkmass

There should be spaces between compnaywhere

wumingzhe

Why is it so messy, edit it

set @strSql ='insert into #indextable(CompanyID,CompanyName,Address,Phone,Place)'+
'select CompanyID, CompanyName,Address,Phone,Place from Company
               where Place like %'+@strPlace+'%'

exec(@strSql)

hiqwolfzzh

Because under normal circumstances, there should be ``behind the like'' to include
So here single quotes involve variable calls and string padding,
So Place like ``%'+@strPlace+'%''

wumingzhe

Thank you ok

fanfan1980

set @strSql ='insert into #indextable(CompanyID,CompanyName,Address,Phone,Place)'+
'select CompanyID, CompanyName,Address,Phone,Place from Company where Place like''%'+@strPlace+'%'''
exec(@strSql)

byron21

To sum up, the correct statement is:
set @strSql ='insert into #indextable(CompanyID,CompanyName,Address,Phone,Place)'+
'select CompanyID, CompanyName,Address,Phone,Place from Company where Place like''%'+@strPlace+'%'''
exec(@strSql)
There are 2 mistakes: one is that there is no space before; the other is that two %s need to be quoted.