--try
declare @sr nvarchar(50)
set @sr='http://www.online.cq.cn'
select count(vcome) from [view] where vcome like '%'+@sr+'%'
declare @sr nvarchar(50)
set @sr='http://www.online.cq.cn'
select count(vcome) from [view] where vcome like '%'+@sr+'%'
set @sr='http://www.online.cq.cn'
select count(vcome) from [view] where vcome like '%'+@sr+'%'
set @sr="http://www.online.cq.cn"
select count(vcome) from [view] where charindex(@sr,vcome)>0
服务器: 消息 207,级别 16,状态 3,行 3
列名 'http://www.online.cq.cn' 无效。
set @sr='http://www.online.cq.cn'
select count(*) from [view] where vcome like '%'+@sr+'%'