根据标题搜索信息
<div style="font-size: 16px;">USEGO
/****** Object: StoredProcedure . 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 .
@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
页:
[1]