Saturday, December 16, 2006

Stored Procedure using Parameterized TOP clause

CREATE PROCEDURE spTopRecords
@Top int
as
-- set how many records to return
SET ROWCOUNT @Top
SELECT * FROM
SET ROWCOUNT 0

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home