The procedure below is wrong,
@i couldn't be used after top?Why?
--================================
create procedure proce
(
@i int
)
as
select top @i * from userinfo

I am really comfused!!

AFAIK, this is by design. The TOP clause needs to be a constant to work correctly.

You could try using SET ROWCOUNT, like this:

CREATE PROCEDURE proce

@i int

AS

SET ROWCOUNT @i

SELECT * FROM userinfo

Look in the Books Online for SQL Server and read about the TOP Keyword. That topic also discusses the differences between using TOP and using SET ROWCOUNT


Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

If you can hang on for the next version of SQL (2005) you can use expressions in the TOP statement :)

--

Joe

thank u!