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
@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