How do I use a variable in a TOP clause in SQL Server 2000?

CREATE PROCEDURE dbo.getFoo

    @top INT

AS

BEGIN

    SET ROWCOUNT @top

 

    SELECT foo

        FROM blat

        ORDER BY foo DESC

    -- never forget to set it back to 0!

    SET ROWCOUNT 0

END

GO


Sunday, January 13, 2008 | Add Comment

New Comment

Your Name:
Email (for internal use only):
Subject:
Comment:
 
Code above:

Categories

Recent Tweets

Valid XHTML 1.0 Transitional