<p><br>
DECLARE @Key varchar(30)<br>
SET @Key='新'<br>
SELECT * FROM dbo.NewsInfo WHERE <br>
Title <span style="color: #ff0000;">like N'%'+@key+'%' </span>
OR ArticleInfo<span style="color: #888888;"> <span style="color: #ff0000;">L</span>
<span style="color: #ff0000;">IKE N'%'+@Key+'%'</span>
<br></span>
</p>
DECLARE @Key varchar(30)<br>
SET @Key='新'<br>
SELECT * FROM dbo.NewsInfo WHERE <br>
Title <span style="color: #ff0000;">like N'%'+@key+'%' </span>
OR ArticleInfo<span style="color: #888888;"> <span style="color: #ff0000;">L</span>
<span style="color: #ff0000;">IKE N'%'+@Key+'%'</span>
<br></span>
</p>