create PROCEDURE [dbo].[UP_News_Search]
@Title varchar(50)
AS
SELECT
ID,TypeID,TypeName,Title,Source,ViewCount,Contents,IsHome,CreateTime
FROM [News]
WHERE Title like '%'+@Title+'%'
模糊搜索存储过程Sql语句
最新推荐文章于 2024-01-02 22:12:28 发布
create PROCEDURE [dbo].[UP_News_Search]
@Title varchar(50)
AS
SELECT
ID,TypeID,TypeName,Title,Source,ViewCount,Contents,IsHome,CreateTime
FROM [News]
WHERE Title like '%'+@Title+'%'