存储过程-根据类别ID取出该类别下所有新闻.(所属类别,新闻标题,发表时间)
SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =============================================-- Author: 阿康-- Create date: 2010-01-01-- Description: 根据类别ID取出该类别下所有新闻.(所属类别,新闻标题,发表时间)-- =============================================CREATE PROCEDURE News_SelectByCaId @caid intASBEGIN 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 descENDGO
?
