ALTER PROCEDURE [dbo].[ReGet_AllwebInfoDescription]
@ReSearch nvarchar(800)
AS
BEGIN
SET NOCOUNT ON;
select @ReSearch= '%'+(@ReSearch)+'%';
SELECT ID,Title,CreateDate
from ArticleModel
where Description IS NOT NULL AND PATINDEX(@ReSearch,Description)>0
ENDsql的存储过程
@ReSearch nvarchar(800)
AS
BEGIN
SET NOCOUNT ON;
select @ReSearch= '%'+(@ReSearch)+'%';
SELECT ID,Title,CreateDate
from ArticleModel
where Description IS NOT NULL AND PATINDEX(@ReSearch,Description)>0
ENDsql的存储过程
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货