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