using TOP with arguments - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

using TOP with arguments

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-11-29 : 21:08:01

chun writes "CREATE PROCEDURE SP_test
@topclients int
AS
select top @topclients * from account
GO

gives me an error, I want to return the top xx row of the table. what could be the problem of this stored procedure? thanks for your help..."

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources