SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		 阿康
-- Create date:  2010-01-01
-- Description:	 根据类别ID取出该类别下所有新闻.(所属类别,新闻标题,发表时间)
-- =============================================
CREATE PROCEDURE News_SelectByCaId 
@caid int
AS
BEGIN
	 Select n.id,c.[name],n.title,n.createtime from news n
	 inner join category c on c.id=n.caid and n.caid=@caid
	 order by n.createtime desc
END
GO

?