首页 › C++ › 根据类别id取出该类别下相应的新闻

epai 发表于 2013-2-5 01:08:14

根据类别id取出该类别下相应的新闻

USE
GO
/****** Object:  StoredProcedure .    Script Date: 05/12/2010 12:19:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:  韩慧
-- Create date: 2010-4-15
-- Description:根据类别id取出该类别下相应的新闻
-- =============================================
ALTER PROCEDURE .
 @caid int
AS
BEGIN
 SELECT n.id,n.title,n.createtime ,n.caid ,c.name from news n
 inner join category c on n.caid=c.id and n.caid=@caid
 order by n.createtime desc
END

查看完整版本: 根据类别id取出该类别下相应的新闻