帮忙看一下sql语句再sql 2000中是怎么识别的?
declare @mode varchar(10)
set @mode ='1234'
select * from whf where customerid like '%'+ @mode +'%'
与
select * from whf where customerid like ''%'+ @mode +'%''
的区别
在select * from whf where customerid like '%'+ @mode +'%'中怎莫再@mode两边加上' '