CREATE PROC TopTitles(@count INT)
AS
SELECT TOP (@count) title FROM pubs..titles
ORDER BY ytd_sales DESC


CREATE PROC TopTitles2(@count INT)
AS
SET ROWCOUNT @count
SELECT title FROM pubs..titles
ORDER BY ytd_sales DESC
SET ROWCOUNT 0
a
b
c
d
