注意:@num 要用括号括起来!
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- =============================================
-- Author: keithray
-- Create date: 2011-8-30
-- Description: 根据新闻类别ID取出改类别下的num条新闻
-- =============================================
ALTER PROCEDURE [dbo].[news_SelectNumByLanmuId]
@LanmuId int,
@num int
AS
BEGIN
select top (@num) title from news where lanmuId=@LanmuId order by createTime desc//注意:@num要用括号括起来
END