原先select top @n 这样提示错误,SQL2005中增加了如下方法,方便很多:
ALTER PROCEDURE [dbo].[GetBbsTitleByLanMu]
(@top int, )
as
declare @n int
set @n = @top
select top(@n) * from BbsConten
原先select top @n 这样提示错误,SQL2005中增加了如下方法,方便很多:
ALTER PROCEDURE [dbo].[GetBbsTitleByLanMu]
(@top int, )
as
declare @n int
set @n = @top
select top(@n) * from BbsConten