创建存储过程
create procedure procSNewsSelectNewNews
as
begin
select top 10 n.id , n.title , n.createTime , c.[name] from news n
inner join category c on n.caID = c.id
order by n.createrTime desc
end
go
验证存储过程
exec procSNewsSelectNewNews
创建存储过程
create procedure procSNewsSelectNewNews
as
begin
select top 10 n.id , n.title , n.createTime , c.[name] from news n
inner join category c on n.caID = c.id
order by n.createrTime desc
end
go
验证存储过程
exec procSNewsSelectNewNews