根据类别id取出新闻的内容;

ALTER PROCEDURE [dbo].[SelectBycaidList]
@id int
AS
BEGIN

select  n.id,[name],title,createtime,n.caid from news n join category c on n.caid=c.id and n.caid=@id
order by createtime desc
END