依据标题搜索信息

根据标题搜索信息

USE [Publishing System ]
GO
/****** Object:? StoredProcedure [dbo].[procselectnewsbycontent]??? Script Date: 05/12/2010 12:44:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:??韩慧
-- Create date: 2010-4-15
-- Description:?根据标题搜索信息
-- =============================================
ALTER PROCEDURE [dbo].[procselectnewsbycontent]
?@content varchar(200)
AS
BEGIN
?SELECT n.id,n.caid,n.title,n.createtime ,c.name from news n
?inner join category c on c.id=n.caid
?where n.content like '%'+@content+'%'
?order by createtime desc
?END