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
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