sql2005与sql2000的语法区别

1.sql2005中的存储过程

CREATE PROCEDURE [dbo].[GetNewsAllPage]
 -- Add the parameters for the stored procedure here
  (@PageIndex int,
      @PageSize int)
AS
BEGIN
 -- SET NOCOUNT ON added to prevent extra result sets from
 -- interfering with SELECT statements.
 SET NOCOUNT ON;

    -- Insert statements for procedure here
  if (@PageIndex=1)
   begin
       select TOP(@PageSize) * from TableNews order by NewsId desc
   end
 else
   begin
    Select TOP (@PageSize) * from TableNews where (NewsId <
    (Select Min(NewsId) From
     (Select TOP ((@PageIndex-1)*@PageSize) NewsId from TableNews order by NewsId desc)
    as T))
    order by NewsId desc
   end
EN